Re: Generating CREATE TABLE statements

Jack Miller wrote:
> 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

Please do not feel compelled to multipost to every usenet group you can spell.

SELECT dbms_metadata.get_data('TABLE', '<you_table_name>') FROM dual;

Demos of the dbms_metadata package can be found in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)