oracle:从其他类型的选项卡中选择 *?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4957547/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 22:43:31  来源:igfitidea点击:

oracle: select * from tab for other types?

oraclesys

提问by chris

I can do a

我可以做一个

select * from tab;

and get a list of tables (and apparently views) - are there similar views set up for other objects, such as sequences, etc?

并获取表格列表(显然是视图)-是否为其他对象(例如序列等)设置了类似的视图?

回答by a_horse_with_no_name

Yes, there are (ALL_OBJECTS, ALL_TABLES, ALL_SEQUENCES, ...)

是的,有 (ALL_OBJECTS, ALL_TABLES, ALL_SEQUENCES, ...)

All of them are documented in the manual:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm

所有这些都记录在手册中:http:
//download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm