Re: simple question i'm sure, HELP!

In article <Pine.OSF.3.95.961123151900.28095C-100000_at_brain.uccs.edu>, <kdblakel_at_mail.uccs.edu> writes:
> Path: news.ou.edu!news.nodak.edu!netnews1.nwnet.net!netnews.nwnet.net!arclight.uoregon.edu!feed1.news.erols.com!tezcat!news.bbnplanet.com!cam-news-hub1.bbnplanet.com!uunet!in3.uu.net!csnews!boulder!brain.uccs.edu!kdblakel
> From: KEVIN!!! <kdblakel_at_mail.uccs.edu>
> Newsgroups: comp.databases.oracle
> Subject: simple question i'm sure, HELP!
> Date: Sat, 23 Nov 1996 15:20:31 -0700
> Organization: University of Colorado at Boulder
> Lines: 15
> Message-ID: <Pine.OSF.3.95.961123151900.28095C-100000_at_brain.uccs.edu>
> NNTP-Posting-Host: brain.uccs.edu
> Mime-Version: 1.0
> Content-Type: TEXT/PLAIN; charset=US-ASCII
> X-Sender: kdblakel_at_brain.uccs.edu
>
> Ok, I am new to this database world and this is actually for a class
> project. We are using Desinger 2000 and Oracle 7 at school and I would
> just like to know how through SQL Plus you can get a list of tables within
> your repository? Any help would be great.....
>
> Thanks
> Kevin
>
>
>
>
>
>
>
>
>
Select table_name from all_tables;

or add a where clause like

where owner = 'WhoEverCreatedYourTables';

Martin Douglas Received on Sun Nov 24 1996 - 00:00:00 CET