Re: sho command
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 01 Jan 2008 12:09:50 GMT
Message-ID: <477a2d8e$0$1344$834e42db@reader.greatnowhere.com>
Date: 01 Jan 2008 12:09:50 GMT
Message-ID: <477a2d8e$0$1344$834e42db@reader.greatnowhere.com>
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.comReceived on Tue Jan 01 2008 - 06:09:50 CST