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: Beginner question

Re: Beginner question

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Fri, 17 Dec 1999 09:39:44 -0500
Message-ID: <385A4B30.444C9528@Unforgettable.com>


texas_mike_at_my-deja.com wrote:
>
> What is the SQL command used to find the list of tables in the database
> and to find the list of fields in the tables? Isn't there a system
> table that can be queried?
>
> Thanks.
>
> --
> -----------------------------
> TEXAS_MIKE_at_MY-DEJANEWS.COM
> Hey haven't we met?
> -----------------------
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

SELECT DISTINCT OWNER||'.'||TABLE_NAME
FROM SYS.DBA_TABLES; Received on Fri Dec 17 1999 - 08:39:44 CST

Original text of this message

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