Re: command to list all user tables

Mark.Powell_at_eds.com (Mark D Powell) wrote in <2687bb95.0405041506.62328d2f_at_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 --
>

I remember going to a bookstore and seeing a wall of Oracle books. Can you be more specific about the name of the SQL manual? Received on Wed May 12 2004 - 15:43:10 CDT