dbms_metadata - MemoSoup

Oracle: using DBMS_METADATA for getting table structure

SET LONG 5000 SELECT dbms_metadata.get_ddl(’TABLE’,'EMP’,'SCOTT’) FROM dual;

Some other values of the type field for dbms_metadata.get_ddl function:

INDEX DB_LINK PACKAGE

(See also “Oracle® Database PL/SQL Packages and Types Reference“)

The best method is to use dbms_metadata package:

SELECT dbms_metadata.get_ddl(UPPER(’&OBJ_TYPE’),UPPER(’&OBJ_NAME’),UPPER(’&OWNER’)) FROM dual;

Additional methods could be also used: Source text of the package

SELECT text FROM dba_source WHERE UPPER(name) LIKE UPPER(’&which_object’) ORDER BY line ;

Use $ORACLE_HOME/bin/wrap utility to encrypt the package (there is no unwrap) (Well, actually, there is unwrap – just look in [...]