470,849 Members | 1,590 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

user_tab_columns

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.
Jul 19 '05 #1
4 8587

"Greg Bailey" <cl*************@yahoo.co.uk> wrote in message
news:b5************************@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
Jul 19 '05 #2
cl*************@yahoo.co.uk (Greg Bailey) wrote in message news:<b5************************@posting.google.co m>...
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.


Hmm. Try rerunning the query?

I assume you mean REFRESHING the data you see versus trying to UPDATE
those views. The data should not change much, so why you'd have
problems seeing the most recent values might be due to something else
(maybe your session privileges).

HTH,
ed
Jul 19 '05 #3
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
Jul 19 '05 #4
I was misunderstanding some of the values in the view it appears.

I had assumed that data_length was the length of data in the column,
but this doesn't apply to numbers, where data_precision is the field I
want (as far as I can tell).

Thanks
Greg
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Tom Jones | last post: by
3 posts views Thread by Thierry B. | last post: by
1 post views Thread by Prashant | last post: by
8 posts views Thread by cbtguy_2000 | last post: by
4 posts views Thread by Greg Bailey | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.