Re: basic sqlplus question

From: Madhu Cherukuri <Madhu.Cherukuri_at_worldnet.att.net>
Date: 1998/02/25
Message-ID: <6d2mdp$i8r@bgtnsc01.worldnet.att.net>#1/1

Try this

select object_name, object_type,owner from sys.dba_tables;

will list all the objects in the database. You can filter the query to your requirement using where condition with object_type (TABLE, SEQUENCE, PROCEDURE etc.) and owner (who owns the objects)

HTH Madhu Cherukuri

Martin Meadows wrote in message <6d2c6q$lkb$1_at_news.indy.net>...
>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 Wed Feb 25 1998 - 00:00:00 CST