Table information script

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 13 Aug 2009 18:57:27 -0700 (PDT)

Can somebody share the query that can give the table information with Primary 
and Foregin Key as shown in tools like Toad or as shown below

Owner   TableName   ColumnName   DataType    Null/NotNull        
PrimaryKey(Y/N)   Foreign Key(Y/N)   ParentTable


TIA
Sanjay

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Other related posts: