-
Table Definitions
Can someone Please tell me where can i find table and column definitions in a particular schema.
Md. Shiraz Mustafa
Oracle Consultant
-
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
-
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.
Last edited by mrchrispy; 04-21-2004 at 08:01 AM.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|