Generating CREATE TABLE statements

#1 June 27th, 2008, 08:03 PM

Hi,

Is there any SQL command in Oracle that returns a "CREATE TABLE"
statement in Oracle. For example in MySQL there is a command called

"SHOW CREATE TABLE <tableName>"

This command can be sent from any client and it returns the script for
the table.

Thanks

#2 June 27th, 2008, 08:03 PM

"Jack Miller" <jm@asdfaf.comwrote in message
news:swrDf.2327$0J3.1435@trndny08...

Quote:

Hi,
>
Is there any SQL command in Oracle that returns a "CREATE TABLE"
statement in Oracle. For example in MySQL there is a command called
>
"SHOW CREATE TABLE <tableName>"
>
This command can be sent from any client and it returns the script for
the table.
>
Thanks

look at the docs under pl/sql packages dbms_metadata.
Jim

Generating CREATE TABLE statements

re: Generating CREATE TABLE statements

/bytes/development

/bytes/it

/bytes/about