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: basic sqlplus question

Re: basic sqlplus question

From: John Loughlin <ronan_at_monet.bestweb.net>
Date: 1998/02/26
Message-ID: <Pine.NEB.3.96.980226114833.16736B-100000@monet.bestweb.net>#1/1

Try these.

Select table_name from user_tables
or
select table_name from dba_tables
or
select table_name from all_tables


John Loughlin          Pi Information Technologies, Inc.
ronan_at_bestweb.net      Database Software Design and Development 
jml_at_dti.net            voice:  914 945 0310

On 26 Feb 1998, Martin Meadows wrote:

> Hi. I'm an Oracle novice with a simple question. In sqlplus, is there a
> way to see a list of all the Oracle tables that are out there?
>
> Thanks for the information!
>
> Marty Meadows
>
>
>
Received on Thu Feb 26 1998 - 00:00:00 CST

Original text of this message

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