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.

Start off with:_

        SELECT * FROM DICTIONARY; Complain to your DBA if it isn't there, as the other user views of the data dictionary won't be.

Then

        DESCRIBE <table_you're_interested_in>

--
Mark Bluemel	Unix/Oracle Trainer and Consultant
		My opinions are my own, but I'll share them
		All solutions to problems are offered "as is"
		and without warranty - you have been warned :-)