Display all views on oracle database

database oracle view oracle-sqldeveloper

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

database oracle view oracle-sqldeveloper

Open a new worksheet on the related instance (Alt-F10) and run the following query

SELECT view_name, ownerFROM sys.all_views ORDER BY owner, view_name

database oracle view oracle-sqldeveloper

SELECT * FROM DBA_OBJECTS  WHERE OBJECT_TYPE = 'VIEW'

CodeHunter