user_tab_columns

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Greg Bailey
    #1

    user_tab_columns

    How do I update the views user_tab_column s 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.
    Tags: None
    • Mark C. Stock
      #2
      Re: user_tab_column s


      "Greg Bailey" <climbingmercur y@yahoo.co.ukwr ote in message
      news:b50df850.0 409130230.78e5b 8@posting.googl e.com...
      | How do I update the views user_tab_column s 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


        Comment

        • Ed prochak
          #3
          Re: user_tab_column s

          climbingmercury @yahoo.co.uk (Greg Bailey) wrote in message news:<b50df850. 0409130230.78e5 b8@posting.goog le.com>...
          How do I update the views user_tab_column s 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

            Comment

            • Hans Forbrich
              #4
              Re: user_tab_column s

              Greg Bailey wrote:
              How do I update the views user_tab_column s 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

                Comment

                • Greg Bailey
                  #5
                  Re: user_tab_column s

                  I was misunderstandin g 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

                    Comment

                    Previous template Next
                    Working...