Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: NEWBIE: SQL intro

Re: NEWBIE: SQL intro

From: Paul Bennett <spacey845_at_my-deja.com>
Date: Mon, 16 Oct 2000 16:18:08 GMT
Message-ID: <8sf9no$kp4$1@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.
Received on Mon Oct 16 2000 - 11:18:08 CDT

Original text of this message

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