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: view tables

Re: view tables

From: Kelvin Baggs <kelvinb_at_AustraliaMail.com>
Date: Thu, 2 Jul 1998 19:16:18 +1000
Message-ID: <6nfjf0$93t$1@grissom.powerup.com.au>


Cyril

Try the following SQL:

select table_name
from user_tables; -- Shows only your tables

from all_tables -- All tables in the database, if you have select permission

Regards
Kelvin

Cyril Matalon wrote in message <359B4264.331A_at_jouy.inra.fr>...
>I would like to know how I can see the names of the tables in a data
>base with a sql command.
>
> Thanks.
> Cyril Matalon.
Received on Thu Jul 02 1998 - 04:16:18 CDT

Original text of this message

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