Re: command to list all user tables

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 4 May 2004 16:06:17 -0700
Message-ID: <2687bb95.0405041506.62328d2f@posting.google.com>

"Anna C. Dent" <anacedent_at_hotmail.com> wrote in message news:<c7Clc.59289$Jy3.49735_at_fed1read03>...
> David Wright wrote:
> > I have a list of tables but can't remember the command to print all the table
> > names and their fields.
> >
> > Is there a command?
> >
> > I have three books on Oracle: Tuning, A beginers guide and DBA Handbook. Is
> > there another book which just has "non-sql" sql commands?
>
> select * from DBA|ALL|USER_TAB_COLUMNS

David, to add to what Anna said the "non-sql" SQL comands are documented in the SQL manual along with the rest of the SQL commands.

The Oracle Data Dictionary tables are documented in the Oracle version# Reference manual. The is a dictionary view for every major database object: table, view, synonym, indexes, constraints, etc....

HTH -- Mark D Powell -- Received on Tue May 04 2004 - 18:06:17 CDT