Re: SQL plus Question: how to 'describe' all?

From: Olivier Bercovitz <oberco_at_club-internet.fr>
Date: 1998/08/13
Message-ID: <35D35884.D8436BCB@club-internet.fr>#1/1

Hello,
you can do this with sqlplus and spool like this :

sql > spool mytable.sql

sql > select 'desc ' || table_name from user_tables;
sql > spool off
sql > @mytable.sql

do the same with object_name from user_objects

Hope this help's

Regards.
Olivier

m_van_basten_at_hotmail.com wrote:

> How can I 'describe' all tables or procedure for a specific user at the same
> time?
>
> Thanks.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Aug 13 1998 - 00:00:00 CDT