Monday, October 8, 2007

Getting Object information in Oracle

To find out all the table name from oracle of any schema
select * from all_objects where OWNER ='Schema name' where object_type='TABLE/VIEW';

======================================
To find out all the column name from oracle of any table & schema
select * from ALL_TAB_COLUMNS where OWNER ='Schema name'

======================================
u will get all table n comment abt table
select * from dictionary

No comments: