how to see multiple table structures in a single query ?

[vr76413]

hello all..

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
Ron

[slimdave]

Query the dba_tables, dba_tab_columns views for owner = 'WHATEVER'

[DaPi]

Select * From dba_tab_columns Where owner = 'HEAT';

[abhaysk]

User_Tab_Columns... BTW, RTM

[sambavan]

       SET ECHO ON
       SET HEADING OFF
       SET FEDDBACK OFF
       SET PAGESIZE 100
       SPOOL desc_user_tables.sql
       SELECT 'DESC '||table_name FROM dba_tables
       WHERE owner = 'HEAT'
       SPOOL OFF;
       SET HEADING ON
       SET FEDDBACK ON
       @desc_user_tables.sql

Hope this would help you.

Sam