Re: sho command

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. Received on Thu Jan 03 2008 - 00:29:46 CST