home bbs files messages ]

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 1,514 of 2,288   
   Douglas Hawthorne to Prabodh   
   Re: how to make a column at column no X,   
   22 Jun 04 08:51:28   
   
   From: douglashawthorne@yahoo.com.au   
      
   "Prabodh"  wrote in message   
   news:c595dbe9.0406220037.36f00311@posting.google.com...   
   > Hi All,   
   >   
   > Do u know how to make 22nd column a primary key if there is a table of   
   > 100 columns and you don't know the names of the columns?   
   >   
   > If u do know plz reply ASAP.   
   >   
   > Prabodh   
      
   Pradodh,   
      
   The DESCRIBE command in SQL*Plus tells you the names of the columns for a   
   table.   
      
   You can also use the data dictionary view, USER_TAB_COLUMNS, to find the   
   name of the 22nd column of a table.  Use the COLUMN_ID column of that view   
   to find the order that the column was created in.   
      
   Douglas Hawthorne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

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


(c) 1994,  bbs@darkrealms.ca