Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Describe all tables

Re: Describe all tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 26 Aug 1999 17:20:38 +0800
Message-ID: <37C506E6.3FCC@yahoo.com>


HSK wrote:
>
> Hi..
>
> Does anyone have, or know how to make, a SQL-script that describes all
> tables a user owns (Oracle 7.3) ?
>
> regards,
> HSK
spool xyz.sql
select 'desc '||table_name
from user_tables;
spool off
@xyz

--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Aug 26 1999 - 04:20:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US