Path: news.netfront.net!news.glorb.com!postnews.google.com!w56g2000hsf.googlegroups.com!not-for-mail From: Mark D Powell Newsgroups: comp.databases.oracle.server Subject: Re: sho command Date: Tue, 1 Jan 2008 07:16:11 -0800 (PST) Organization: http://groups.google.com Lines: 39 Message-ID: <7ce3245b-a91a-4024-b1b4-7cc599345eef@w56g2000hsf.googlegroups.com> References: <477a2d8e$0$1344$834e42db@reader.greatnowhere.com> NNTP-Posting-Host: 69.245.97.247 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1199200572 32414 127.0.0.1 (1 Jan 2008 15:16:12 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 1 Jan 2008 15:16:12 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: w56g2000hsf.googlegroups.com; posting-host=69.245.97.247; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Xref: news.netfront.net comp.databases.oracle.server:180739 On Jan 1, 7:09 am, Mladen Gogala 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 > > > 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 --