Re: sho command

On Jan 3, 1:29 am, Rosie <rose.rami..._at_cdps.state.co.us> wrote:
> On Dec 31 2007, 5:36 pm, Rosie <rose.rami..._at_cdps.state.co.us> wrote:
>
> > Using Oracle 9i -
>
> > Using PL/SQL
>
> > Is there a command like SQL's show table command that will show all
> > the information for a specific table, like the table columns & size,
> > any views, indexes, procedures, constraints, triggers, etc. associated
> > with the table?
>
> > Also, is there a command to show the dependancies associated to a
> > table?
>
> > Thanks,
>
> THANK YOU to eveyone for the info provided. To give more info, I am
> new to Oracle (learning by books) and need to do a print out of each
> schema by table that includes any indexes, views, procedures,
> triggers, dependencies, etc. associated with the table and all the
> attributes of each.
>
> In Oracle RDB using SQL, you can type the command show table
> table_name and everything created for that table appears - indexes,
> views, triggers, etc. I was hoping there was a command for Oracle
> using PL/SQL that would do the same thing.
>
> Currently, I am using OEM to generate the printouts but was hoping
> there was something else available (less time consuming).
>
> So, if I am understanding correctly, the alternative in getting what I
> am looking for -- the table plus it's indexes, triggers, etc. would
> need to be done programmatically through the information Mark & Mladen
> provided gathering the information from multiple table views specified
> in the dictionary.
>
> Any additional assistance is greatly appreciated.

I have a plsql procedure that uses calls to dbms_metadata ... it loops thru a schema and puts out into separate files the table ( create table ) ddl, primary key ddl, additional indexes, foreign key constraints ... etc.

Do you want me to send you that?

On the other hand you really learn more by finding similar stuff already published on the web or writing it yourself. Received on Thu Jan 03 2008 - 12:56:02 CST