CODEWITHSUNDEEP
databaseoracle-databasevieworacle-sqldeveloper
GrumP
GrumP

Reputation: 1203

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.

Upvotes: 56

Views: 191820

Answers (3)

Ferit Güzel
Ferit Güzel

Reputation: 41

SELECT * 
FROM DBA_OBJECTS  
WHERE OBJECT_TYPE = 'VIEW'

Upvotes: 4

Petr Pribyl
Petr Pribyl

Reputation: 3575

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

Upvotes: 108

GuZzie
GuZzie

Reputation: 974

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

Upvotes: 17

Related Questions