DB Object (table, view, sequence, index )DDL 조회

Table DDL 조회

select DBMS_METADATA.GET_DDL('TABLE', TABLE_NAME ) from USER_OBJECTS where OBJECT_TYPE='TABLE'

VIEW DDL 조회

select DBMS_METADATA.GET_DDL('VIEW', OBJECT_NAME ) from USER_OBJECTS where OBJECT_TYPE='VIEW'

SEQUENCES DDL 조회

select DBMS_METADATA.GET_DDL('SEQUENCE', SEQUENCE_NAME) from USER_SEQUENCES

INDEX DDL 조회

select DBMS_METADATA.GET_DDL('SEQUENCE', SEQUENCE_NAME) from USER_SEQUENCES