Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

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