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

Home -> Community -> Usenet -> c.d.o.server -> Re: Listing for Database / Tables

Re: Listing for Database / Tables

From: Joerg Lanzinger <joerg_at_lanzinger.de>
Date: Tue, 16 Nov 1999 12:32:23 +0100
Message-ID: <383140C7.B3F1DD48@lanzinger.de>


Hi,

try
  SELECT * FROM all_tables; (for all tables in your system) or

  SELECT  *  FROM all_objects;                (for all objects, ie. tables,
indexes, ...)
or
  SELECT * FROM tabs; (all tables for the current user, ie. YOU)

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

Original text of this message

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