Display all views on oracle database

Question

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

Thanks.

Answer 1

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

Answer 2

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

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

Answer 3

SELECT * 
FROM DBA_OBJECTS  
WHERE OBJECT_TYPE = 'VIEW'

Answer 4

You should definitely look at standard INFORMATION_SCHEMA views (they exists in any RDBMS, eg. Oracle, MySQL, SQL Server...), there are lot of information about your database.

Select names of all your views:

SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.VIEWS