Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: view tables
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