1 select object_name ,owner from dba_objects where object_type=upper('table') 2* and owner=upper('scott') SQL> /object_name owner -------------------- ------------------------------ DEPT SCOTT EMP SCOTT BONUS SCOTT SALGRADE SCOTT XS SCOTT KC SCOTT XS_KC SCOTT
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
DBA3 群:63306533; 聊天 群:40132017
回错贴了,1. pl/sql developer 可以直接看到用户相关的信息。
2. windows下可以直接用上下翻动,linux 下需要安装一个包。
2* and owner=upper('scott')
SQL> /object_name owner
-------------------- ------------------------------
DEPT SCOTT
EMP SCOTT
BONUS SCOTT
SALGRADE SCOTT
XS SCOTT
KC SCOTT
XS_KC SCOTT
2.如果是在sql plus中的话,执行上一条命令可以使用 '/' , 然后按一下回车就可以了