Re: SQLPLUS QUESTION

lan <lan_at_bluebird.com> wrote:

>
>Hi all,
>
>What command should I use to list database name and table names
>in SQLPLUS?
>
>thanks.
>
>--Lan
>
>

select * from v$database;
select table_name from user_tables;
select table_name from sys.dba_tables;

Check out the list of data dictionary tables and views in the back of the SQL Language Quick Reference. It's quite handy.

Or call Platinum Technology and tell them you'd like a copy of their Oracle Data Dictionary Poster. It's free. You may have to say you're interested in their DBA tools.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

If at first you don't succeed, skydiving isn't for you.