Path: news.netfront.net!ctu-peer!news.nctu.edu.tw!newsfeed-0.progon.net!progon.net!feeder1.cambrium.nl!feed.tweaknews.nl!138.195.8.3.MISMATCH!news.ecp.fr!news.greatnowhere.com!reader.greatnowhere.com!not-for-mail From: Mladen Gogala Subject: Re: sho command Newsgroups: comp.databases.oracle.server References: User-Agent: Pan/0.132 (Waxed in Black) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Date: 01 Jan 2008 12:09:50 GMT Lines: 28 Message-ID: <477a2d8e$0$1344$834e42db@reader.greatnowhere.com> NNTP-Posting-Date: 01 Jan 2008 12:09:50 GMT NNTP-Posting-Host: 0a3fb59b.reader.greatnowhere.com X-Trace: DXC=TS8d`KCNOWiegGfmE_8EJd]XKbj2VKD@jn1RJ3gdIg\kgWXZZke`H:i2h=o9Y@GCb`55:h3U91eThU]V1IaTm@^d9KN3[3CLNNlSfG9cSGca7e3>I8nLdbQba_0XKK1S`cUHefITeYOeFo^6E5kX=Gn X-Complaints-To: usenet@greatnowhere.com Xref: news.netfront.net comp.databases.oracle.server:180733 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 > 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