Obsidian/Recognition/Programing/Tibero/DDL 스크립트 추출.md

7 lines
191 B
Markdown
Raw Permalink Normal View History

2023-08-14 16:19:25 +00:00
```sql
select to_char(dbms_metadata.get_ddl('TABLE', 'SACP_FLT_DEP_HIST', 'UCI')) from dual
select dbms_metadata.get_ddl('TABLE', TABLE_NAME, OWNER) from all_tables where owner = 'UIC'
```