Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: NEWBIE: SQL intro
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