Get table and index DDL the easy way

Get table and index DDL the easy way

set heading off; set echo off; Set pages 999; set long 90000; spool ddl_list.sql select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual; select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual; spool off;       OR     set long 1000 set pagesize 0 select DBMS_METADATA.GET_DDL('TABLE','EMPLOYEES') from DUAL;   select DBMS_METADATA.GET_DDL('INDEX','EMP_INDX') from DUAL;      //   SQL> column SESSION_USER format A15 SQL> column CURRENT_SEHEMA format A15     SQL> select sys_context('USERENV', 'SESSION_USER') SESSION_USER, 2 sys_context('USERENV', 'CURRENT_SCHEMA') CURRENT_SCHEMA from dual; HR HR       select USER from DUAL;   SHOW USER;     --------- select table_name from user_tables; select table_name from all_tables;   select table_name from dba_tables; select * from tab; select * from cat; select table_name from user_views;  select table_name from all_views;    select table_name from dba_views;      select table_name from user_TAB_COLUMNS;  select table_name from ALL_TAB_COLUMNS;    select table_name from dba_TAB_COLUMNS; select table_name from user_INDEXES;   select table_name from ALL_INDEXES;     select table_name from dba_INDEXES;