Display all views on oracle database

GrumP picture GrumP · Dec 6, 2012 · Viewed 156.8k times · Source

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

Thanks.

Answer

Petr Pribyl picture Petr Pribyl · Dec 6, 2012

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