User_all_tables

Oracle DBMS_METADATA.GET_DDL: Extract Object DDL Purpose Oracle 9i introduced the DBMS_METADATA package. It can retrieve object definitions as DDL or as XML. The function GET_DDL turns that ability into a single query. You give it an object type, an object name and a schema. It returns the creation statement as a CLOB. …