[ORACLE] DBMS_METADATA.GET_DDL

* DDL 조회할 때 사용 

---tablespace

select dbms_metadata.get_ddl('TABLESPACE','USERS') || ' ;' from dual ;

 

---user

desc dba_users

select dbms_metadata.get_ddl('USER','EDU10') || ';' from dual ;

select dbms_metadata.get_ddl('USER','ORACLE_OCM') || ';' from dual ;

 

---index

select dbms_metadata.get_ddl('INDEX','index_name', 'user_name') || ';' from dual ;

 

---constraint

select dbms_metadata.get_ddl('CONSTRAINT','constraint_name', 'user_name') || ';' from dual ;

 

---table

--조회

set line 300

col table_name for a20

col owner for a10

select owner, table_name, tablespace_name from dba_tables where owner='SCOTT';

 

select dbms_metadata.get_ddl('TABLE', 'SALGRADE', 'SCOTT') || ' ;' from dual;

select dbms_metadata.get_ddl('TABLE', 'SALGRADE', 'SCOTT') || ' ;' from dba_tables;