(Source Code) Oracle: using DBMS_METADATA for getting table structure

Oracle: using DBMS_METADATA for getting table structure

 

SET LONG 5000

SELECT dbms_metadata.get_ddl('TABLE','EMP','SCOTT');