SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get CREATE TABLE statement of an EXISTING table.

9571Jun 18 2002

HI there,

From which view I can get the complete CREATE STATEMENT OF an existing table.

For example If i have created a table sample using the DDL
"CREATE TABLE SAMPLE(ID NUMBER(10), VARCHAR2(12));"

Now I want to get this statement using the dictionary tables.
I know for PROCEDURES AND FUNCTIONS I can use USER_SOURCE view, but I don't know which table is
having the ddl data.

Thanks in advance,
Khaleel

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2002

Added on Jun 18 2002

8 comments

1,699 views