Re: sho command

On Jan 1, 7:09 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Mon, 31 Dec 2007 16:36:16 -0800, Rosie 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,
>
> describe <shema.table>
>
> > any
> > views, indexes, procedures, constraints, triggers, etc. associated with
> > the table?
>
> All of that is in ALL_DEPENDENCIES view. You can also utilize the
> DBMS_UTILITY.GET_DEPENDENCY procedure.
>
> > Also, is there a command to show the dependancies associated to a table?
>
> > Thanks,
>
> See above.
>
> --http://mgogala.freehostia.com

Rosie, just about eveything you want or need to know about an Oracle object can be found in the rdbms dictionary. Here is a brief introduction article to information on tables, views, indexes, constraints, etc...

How do I find information about a database object: table, index, constraint, view, etc... in Oracle ? http://www.jlcomp.demon.co.uk/faq/object_info.html

How do I find out which users have the rights, or privileges, to access a given object ? http://www.jlcomp.demon.co.uk/faq/privileges.html

HTH -- Mark D Powell -- Received on Tue Jan 01 2008 - 09:16:11 CST