... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.oracle

Overblown overpriced overengineered SHIT

2,288 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 365 of 2,288

Frank to Siva

Re: Getting structure of a table in quer

12 Sep 03 15:01:51

   From: fvanbortel@netscape.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]