Re: recieve table names with sql?

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:20:48 CDT