Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: command to list all user tables

Re: command to list all user tables

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Mon, 03 May 2004 18:13:43 -0700
Message-ID: <c7Clc.59289$Jy3.49735@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 Received on Mon May 03 2004 - 20:13:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US