Re: Getting structure of a table in query format

From: Frank <fvanbortel_at_netscape.net>
Date: Fri, 12 Sep 2003 15:01:51 +0200
Message-ID: <bjsfo7$aa2$1_at_news4.tilbu1.nb.home.nl>


Siva wrote:

> Hi,
>
> i want to know, how to get the structure of the table in query
> format(create table ...). any one can help me.
>
> bye & thanxs
>
> Siva Prakash. M

Select 'create table '||table_name||'...'   from user_tablea, user_columns, ...

Read the data dictionary view definitions (SQL manual)

-- 
Regards, Frank van Bortel
Received on Fri Sep 12 2003 - 15:01:51 CEST

Original text of this message