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