Re: sho command
Date: 01 Jan 2008 12:09:50 GMT
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,
> 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?
See above.Received on Tue Jan 01 2008 - 06:09:50 CST