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,740 of 2,288   
   Hans Forbrich to Greg Bailey   
   Re: user_tab_columns   
   13 Sep 04 18:44:27   
   
   From: forbrich@yahoo.net   
      
   Greg Bailey wrote:   
      
   > 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.   
      
   Based on the wording, you seem to have a misconception about views and/or   
   the data dictionary.  I don't quite understand your problem.   
      
   Hopefully you understand the difference between the 'user_' and the 'dba_'   
   views?  (And hopefully you understand what a view actually is!)   
      
   /Hans   
      
   --- 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