Re: Generating CREATE TABLE statements

"Jack Miller" <jm_at_asdfaf.com> wrote in message news:swrDf.2327$0J3.1435_at_trndny08...
> 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 Received on Mon Jan 30 2006 - 20:20:02 CST