Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Beginner question
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
![]() |
![]() |