Generating CREATE TABLE statements

#1

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

"Jack Miller" <jm (AT) asdfaf (DOT) com> wrote

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Generating CREATE TABLE statements

comp.databases.oracle comp.databases.oracle

Generating CREATE TABLE statements - 01-30-2006 , 10:53 AM

Re: Generating CREATE TABLE statements - 01-30-2006 , 08:20 PM