Re: user_tab_columns
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 13 Sep 2004 08:14:16 -0400
Message-ID: <AOqdnQeW_uK_EtjcRVn-uw_at_comcast.com>
Date: Mon, 13 Sep 2004 08:14:16 -0400
Message-ID: <AOqdnQeW_uK_EtjcRVn-uw_at_comcast.com>
"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 - 14:14:16 CEST