Display all views on oracle database

DatabaseOracleViewOracle Sqldeveloper

Database Problem Overview

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

Thanks.

Database Solutions

Solution 1 - Database

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

Solution 2 - Database

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

Solution 3 - Database

SELECT * 
FROM DBA_OBJECTS  
WHERE OBJECT_TYPE = 'VIEW'
Categories
Recommended Database Solutions
Recommended Oracle Solutions
Recommended View Solutions
Recommended Oracle Sqldeveloper Solutions

Previous Solution:

What is a good way to get the filename from a URL in Ruby?

RubyUrlUri

Next Solution:

What do the ENT_HTML5, ENT_HTML401, ... modifiers on html_entity_decode do?

PhpHtmlHtml EntitiesHtmlspecialchars

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionGrumPView Question on Stackoverflow
Solution 1 - DatabasePetr PribylView Answer on Stackoverflow
Solution 2 - DatabaseGuZzieView Answer on Stackoverflow
Solution 3 - DatabaseFerit GüzelView Answer on Stackoverflow