Getting structure of a table in query format

[Siva]

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

[Frank]

Re: Getting structure of a table in query format

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

[Daniel Roy]

Re: Getting structure of a table in query format

If you're on 9i, look up how to use the package DBMS_METADATA ("desc
DBMS_METADATA from SQL*Plus).

Daniel

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