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