Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: recieve table names with sql?
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