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
oracle: select * from tab for other types?
提问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