Re: NEWBIE: SQL intro

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 16 Oct 2000 19:05:04 +0200
Message-ID: <971716147.2621.1.pluto.d4ee154e@news.demon.nl>

"Paul Bennett" <spacey845_at_my-deja.com> wrote in message news:8sf9no$kp4$1_at_nnrp1.deja.com...
> In article <8sf913$k5r$1_at_nnrp1.deja.com>,
> oratune_at_aol.com wrote:
> > In article <8sf862$jfu$1_at_nnrp1.deja.com>,
> > Paul Bennett <spacey845_at_my-deja.com> wrote:
> > > Very stupid newbie question about SQL.
> > >
> >
> > Try this:
> >
> > select owner, table_name, tablespace_name
> > from all_tables;
> >

>

> Thanks! It's bloody obvious once I see it in print in front of me!

>
>
>

> ---
> Pb
> My opinions are my own and should not be taken as
> representing any other group or entity.

>
>

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Actually you should know there are three levels: user_tables |indexes : your own tables etc. all_tables|indexes: all the tables you have access to. dba_tables|indexes: all tables in the database.

This could mean the answer from mr. oratune is only partially correct.

Regards,

Sybrand Bakker, Oracle DBA Received on Mon Oct 16 2000 - 12:05:04 CDT