Re: SQLPLUS QUESTION - list tables

On Mar 19, 1996 19:37:25 in article <Re: SQLPLUS QUESTION>, 'ghp_at_infosoft.be (Gerard H. Pille)' wrote:    

>In article <4iko9n$evo_at_news2.cts.com>, lan (lan_at_bluebird.com) says...
>!>
>!>
>!>Hi all,
>!>
>!>What command should I use to list database name and table names
>!>in SQLPLUS?
>!>
>!>thanks.
>!>
>!>--Lan
>!>
>!>
>
>I believe the database name is one of V$PARAMETER.
>I don't know about the table-names, though.
>--
>Kind reGards
>\ / |
>X |
>/ \ s
>Gerard
>

-- 
 
I'm new to Oracle, but I think I know this one: 
 
try 
 
select table_name from user_tables; 
 
 
Aaron Goldman