Search code examples
databaseoracle-databasevieworacle-sqldeveloper

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.


Solution

  • 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