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: How to list tables or views? (Beginner)

Re: How to list tables or views? (Beginner)

From: Gene Plagge <gplagge_at_hotmail.com>
Date: Wed, 4 Nov 1998 09:01:26 -1000
Message-ID: <F42CB9DBDC42D211B39F00AA00AF328201E646FD@Keiki.Hpu.Edu>


Just as a clarification, the all_<whatever> data dictionary views list all the objects that you have access to, but not all the objects in the entire database. If you want all the views in the entire DB, then use the dba_<whatever> data dictionary views:

select view_name from dba_views;
select table_name from dba_tables;
etc...

Stewart Burnett wrote in message <71mhrk$4rs$1_at_hagen.cloud9.co.uk>...
>To find all views:-
>Select view_name from all_views;
>To find your views :-
>Select view_name from user_views;
>To find all tables:-
>Select table_name from all_tables;
>To find your tables:-
>Select table_name from user_tables;
>
>Stewart Burnett
>
>Please remove 'nospam' from address when replying direct.
>
>
>Zhang LinZai wrote in message <363EABFB.5C89F388_at_email.mot.com>...
>>Please advise how to list tables or views in Oracle?
>>
>>--
>>best regards,
>>Zhang LinZai
>>
>>Email: fchn088_at_email.mot.com
>>
>>
>
Received on Wed Nov 04 1998 - 13:01:26 CST

Original text of this message

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