oracle:从其他类型的选项卡中选择*?
我可以执行
select * from tab;
并获取表列表(显然还有视图) - 是否为其他对象(例如序列等)设置了类似的视图?
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?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
是的,有(ALL_OBJECTS,ALL_TABLES,ALL_SEQUENCES,...)
所有这些都记录在手册中:
http://download.oracle.com/docs/cd /B19306_01/server.102/b14237/toc.htm
Yes, there are (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