Re: user_tab_columns

"Greg Bailey" <climbingmercury_at_yahoo.co.uk> wrote in message news:b50df850.0409130230.78e5b8_at_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 Received on Mon Sep 13 2004 - 07:14:16 CDT