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

Home -> Community -> Usenet -> c.d.o.misc -> Re: recieve table names with sql?

Re: recieve table names with sql?

From: Wolfgang Götzinger <wolfgang.goetzinger_at_siemens.at>
Date: Wed, 03 Jul 2002 12:25:27 +0200
Message-ID: <3D22D117.52BF8389@siemens.at>


Thats it!!!

thanx for the quick answer!

regards,
Wolfgang

Alistair Thomson wrote:

> Hi
>
> Connect to sqlplus as system/manager and try
>
> select owner,table_name from dba_tables order by owner, table_name;
>
> There are several other views you could query for this information too.
>
> Alistair
>
> "Wolfgang Götzinger" <wolfgang.goetzinger_at_siemens.at> wrote in message
> news:3D22CE68.CBA903E_at_siemens.at...
> > Hi!
> >
> > Is it possible to query the table names of an oracle 8.1.7 with sql?
> > How?
> >
> > thanx,
> > Wolfgang
> >
> >
Received on Wed Jul 03 2002 - 05:25:27 CDT

Original text of this message

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