Tag: all_views

  • Display List of All Views on Oracle Database

    Oracle Views These are queries that you can used to display the views on Oracle. ALL_VIEWS describes the views accessible by logged user. select * from all_views DBS_VIEWS describes all views however you need DBA priviledges for this query. select *  from dba_views USER_VIEWS describes the views owned by logged user. select *  from user_views Also you…