I tried doing via command in SQL Plus window this way but doesn't work:
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE', WANT_AD) FROM CLASSMATES;
SELECT DBMS_METADATA.GET_DDL('TABLE', WANT_AD) FROM CLASSMATES
*
ERROR at line 1:
ORA-00942: table or view does not exist
WANT_AD is the table and CLASSMATE is the schema. How do I display the DLL command that created the table?
no idea
all i know is in SQL Navigator, you can right click on a table and say Extract DDL