Re: Beginner question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 18 Dec 1999 19:31:32 +0800
Message-ID: <385B7094.60A5@yahoo.com>

Kenneth C Stahl wrote:
>
> 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;
I'm curious - why the distinct ?

Cheers
Connor
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Dec 18 1999 - 05:31:32 CST