database 显示 oracle 数据库上的所有视图
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13742717/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Display all views on oracle database
提问by GrumP
Is there a way to display all the views currently set on an oracle database via sql developer?
有没有办法通过 sql developer 显示当前在 oracle 数据库上设置的所有视图？
Thanks.
谢谢。
回答by Petr Pribyl
for all views (you need dba privileges for this query)
对于所有视图（此查询需要 dba 权限）
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
回答by GuZzie
Open a new worksheet on the related instance (Alt-F10)and run the following query
在相关实例上打开一个新工作表(Alt-F10)并运行以下查询
SELECT view_name, owner
FROM sys.all_views
ORDER BY owner, view_name
回答by Ferit Güzel
SELECT *
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'VIEW'
回答by Pavel Hodek
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.
您绝对应该查看标准的 INFORMATION_SCHEMA 视图（它们存在于任何 RDBMS 中，例如 Oracle、MySQL、SQL Server...），有很多关于您的数据库的信息。
Select names of all your views:
选择所有视图的名称：
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
