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,738 of 2,288   
   .com to Greg Bailey   
   Re: user_tab_columns   
   13 Sep 04 08:14:16   
   
   From: mcstockX@Xenquery   
      
   "Greg Bailey"  wrote in message   
   news:b50df850.0409130230.78e5b8@posting.google.com...   
   | How do I update the views user_tab_columns and dba_tab_columns?   
   |   
   | I am using Oracle 9.   
   |   
   | I am trying to use a select command to find out info about the columns   
   | in some tables - their data_type, data_length and whether they are   
   | nullable.   
      
   You don't -- the RDBMS does when you issue DDL (data definition language)   
   statements, like CREATE TABLE, ALTER TABLE, etc.   
      
   ++ mcs   
      
   --- 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