how to see multiple table structures in a single query ?
i am on Oracle 817. i have a schema named " HEAT". i ahve some 20 odd tables under this schema. now my developers want the structure of all the tables in that schema.
I know we can run DESC < Table name> to see structure of each table. But is there a query where i can run that will get me the structure of all the tables in a particular schema ?
Thans a lot
Query the dba_tables, dba_tab_columns views for owner = 'WHATEVER'
Select * From dba_tab_columns Where owner = 'HEAT';
User_Tab_Columns... BTW, RTM
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Hope this would help you.
SET ECHO ON
SET HEADING OFF
SET FEDDBACK OFF
SET PAGESIZE 100
SELECT 'DESC '||table_name FROM dba_tables
WHERE owner = 'HEAT'
SET HEADING ON
SET FEDDBACK ON
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width