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>
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 BortelReceived on Fri Sep 12 2003 - 15:01:51 CEST