Re: sho command
Date: Tue, 1 Jan 2008 07:16:11 -0800 (PST)
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.
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