Re: DESCRIBE the entire database

From: Oracleguru <oracleguru_at_mailcity.com>
Date: 1998/08/27
Message-ID: <01bdd1d9$8bc20a60$a504fa80@mndnet>#1/1

Hi !

Here is the script that you are looking for:

REM

REM     Author     : Oracleguru
REM     Date       : 01/28/94
REM     File Name  : describe_tables.sql
REM     Usage      : On sqlplus prompt enter: @describe_tables
REM     Description: Describes Tables and Views in Oracle Database.
REM
REM                  To describe objects in a user's Schema
REM                  add the line
REM                     and owner = upper('&1') below
REm                  and on sqlplus prompt enter:
REM                     @describe_tables user_id
REM                  It is assumed that you can access that user's objects.

REM
set heading off feedback off verify off wrap on pause off prompt
prompt Description of Tables and Views is being sent to prompt file $HOME/rep/describe_tables.lst prompt
prompt Please wait ....
set termout off
spool desc1.sql
prompt spool $HOME/rep/describe_tables.lst prompt set termout off
select 'prompt Description of '||object_type,object_name,

'prompt Owned by '||owner||'                                        ',

'desc '|| object_name from all_objects
 where ( object_type = 'TABLE' or

         object_type = 'VIEW' )
order by owner, object_type, object_name /
prompt prompt
prompt prompt

prompt prompt .                     ********** END OF REPORT **********
 

sysdev_at_adpsystems.mb.ca wrote in article <6rs5fu$4ut$1_at_nnrp1.dejanews.com>...
> Hello,
>
> When I studied databases in university,
> we used Sybase. There was a command in Sybase
> that would describe the entire database; show
> all the tables, their field structure, primary
> keys, foreign keys, and so on.
>
> Questions:
>
> What is this command in Sybase?
>
> Is there an equivilent command in Oracle?
> With Oracle's DESCRIBE,
> I can only describe tables and views.
>
> Regards,
>
> Rodger
>
>
> P.S. -
> My ISP is really bad with newsgroups.
> They post late, and delete early. Emails to:
> sysdev_at_adpsystems.mb.ca
> are greatly appreciated.
>
> -----== 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 27 1998 - 00:00:00 CDT