Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to list tables or views? (Beginner)
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
![]() |
![]() |