Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Display all views on oracle database

Is there a way to display all the views currently set on an oracle database via sql developer?

Thanks.

like image 589
GrumP Avatar asked Dec 06 '12 11:12

GrumP


1 Answers

for all views (you need dba privileges for this query)

select view_name from dba_views 

for all accessible views (accessible by logged user)

select view_name from all_views 

for views owned by logged user

select view_name from user_views 
like image 96
Petr Pribyl Avatar answered Nov 09 '22 12:11

Petr Pribyl