DDL 조회1 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_SEQUENCESINDEX DDL 조회 select DBMS_METADATA.GET_DDL('SEQUENC.. 2023. 8. 29. 이전 1 다음