DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Table Definitions

  1. #1
    Join Date
    Apr 2004
    Location
    Riyadh
    Posts
    12

    Question Table Definitions

    Can someone Please tell me where can i find table and column definitions in a particular schema.
    Md. Shiraz Mustafa
    Oracle Consultant

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your first Oracle gig, eh?

    look at dba_tables and dba_tab_columns. Also, you might want to look at the docs at http://tahiti.oracle.com.
    Jeff Hunter

  3. #3
    Join Date
    Apr 2004
    Location
    Riyadh
    Posts
    12
    Thank you Jeff for your information.

    My actual requirement is a short description on the columns in tables of a particular schema

  4. #4
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    are you talking about dictionary and dict_columns views?
    (for a list of user tables you'll have to link it on table_name)

    you'll also be hoping that you actually have comments on your user tables - you could probably count on one hand the number of databases in the world created with column comments.......I know mine don't

    chris

    PS what's the rate for oracle consultants in Saudi then - I fancy a bit of sun.
    Last edited by mrchrispy; 04-21-2004 at 08:01 AM.

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by mrchrispy
    PS what's the rate for oracle consultants in Saudi then - I fancy a bit of sun.
    I spent a month there, I was dreaming of a pork chop and a beer after two weeks! In August you get plenty of sun, if you like teperatures near 50C.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width