Can someone Please tell me where can i find table and column definitions in a particular schema.
Printable View
Can someone Please tell me where can i find table and column definitions in a particular schema.
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.
Thank you Jeff for your information.
My actual requirement is a short description on the columns in tables of a particular schema
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.
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.Quote:
Originally posted by mrchrispy
PS what's the rate for oracle consultants in Saudi then - I fancy a bit of sun.