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

From: <Mujeeb_ur_Rehman_at_hotmail.com>
Date: 1998/08/15
Message-ID: <6r4cmt$dt5$1@nnrp1.dejanews.com>#1/1

Hi :)

I have already posted this before in response to the table documentation. Since u want to describe the procedures as well. Here is the new modified script. Just cut and paste between the lines and u are all set to go.

Hope this help u.

---

set pagesize 0
set heading off
set feedback off
column object_type noprint
Prompt Creating the script file ...
set term off
spool descr.sql

select 'set pagesize 0'||chr(10)||
       'prompt Creating the file descr.lst please wait ...'||chr(10)||
       'set term off'||chr(10)||
       'spool descr.lst'

from dual
/
select object_type,'prompt Description of '||object_type||' '||

       object_name||chr(10)||'desc '|| object_name from user_objects
where object_type in ('TABLE','VIEW','PROCEDURE') order by object_type
/

select 'spool off'||chr(10)||
       'set pagesize 16'||chr(10)||
       'set term on'||chr(10)||
       'prompt'||chr(10)||
       'prompt Now open the file descr.lst to view the required info.'

from dual
/
spool off
set pages 16
set heading on
set feedback on
set term on
prompt
prompt Now run Script descr.sql to obtain the description.

---

In article <6qvkd7$tjm$1_at_nnrp1.dejanews.com>,   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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Aug 15 1998 - 00:00:00 CDT