Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Listing for Database / Tables
Hi,
try
SELECT * FROM all_tables; (for all tables in your system)
or
SELECT * FROM all_objects; (for all objects, ie. tables,indexes, ...)
HTH
Jörg
Silvester Pereira schrieb:
> Hi there,
>
> I have just started to play around with Oracle. I am trying to list all the
> Oracele DB instances within Oracle. With other databases, I normally can
> type in a command such as
>
> Show Tables / Show DB
>
> and I will get a listing of all Tables and Dbs. What is the equivalent
> command in Oracle. I am interested in the In command line command.
>
> Thanks,
> Silvester
Received on Tue Nov 16 1999 - 05:32:23 CST