Re: Hopefully easy question
Date: 1997/09/25
Message-ID: <19970925203900.QAA07054_at_ladder02.news.aol.com>#1/1
Oracle provides various views for this -
Select view_name from all_views
where view_name like 'ALL%'
or view_name like 'USER%'
will give you a full listing.
John
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com
e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/
The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.
>Working with sqlplus, is there a way to see what tables, indexes, etc. are
>available in the current schema? I am used to Informix and there is an
>easy way to do this in their dbaccess utility. I've looked at the help and
>don't see any command that would list tables and indexes in sqlplus.
>
>--------------------------------------------------------------------------
>Dan Cradler Modern Solutions
>dcradler_at_modernsolutions.com Full-Service Web Space Provider
>702-323-3341 http://www.mods.com
>
>
>
>
>
>
>
>
>
>
Received on Thu Sep 25 1997 - 00:00:00 CEST