由04年下半年数工下午第二题引发的系列实验2--查看一个用户模式下的表-优快云博客

本文通过示例展示了如何在Oracle数据库中使用SQL查询不同用户的表信息。首先以普通用户YMC登录并列出其所有者下的表，接着切换到SCOTT用户进行相同操作，并最终以管理员身份展示指定用户的表详情。

使用当前用户

SQL> show user USER is "YMC" SQL> ed Wrote file afiedt.buf 1 SELECT table_name 2* FROM user_tables SQL> / TABLE_NAME ------------------------------ TESTCHAR BIN$d4XzykugS9q6xMpCXf143A==$0 BIN$qaivnHGGQbG2V87+uvICUg==$0 BIN$2vbDpIPIQc+9a/FiTZK0cg==$0 DUPEMP TESTCHARBYTE TESTCHARCHAR BIN$yjG1szGkRfuWMtJjGeEDIA==$0 T TESTPRI BIN$lNOOvpOfQFWXd2khoT4rbw==$0 TABLE_NAME ------------------------------ TEST TESTDATE IMPEXT DUPTESTCASE TESTCASE TESTEXT TB 18 rows selected. SQL> conn scott/tiger Connected. SQL> edit Wrote file afiedt.buf 1 SELECT table_name 2* FROM user_tables SQL> / TABLE_NAME ------------------------------ SALGRADE BONUS EMP DEPT

使用管理员
SQL> conn system Connected. SQL> ed Wrote file afiedt.buf 1 SELECT table_name 2 FROM dba_tables 3* WHERE owner=upper('scott') SQL> / TABLE_NAME ------------------------------ DEPT EMP BONUS SALGRADE SQL> ed Wrote file afiedt.buf 1 SELECT table_name 2 FROM dba_tables 3* WHERE owner=upper('ymc') SQL> / TABLE_NAME ------------------------------ TB TESTCASE DUPTESTCASE TESTEXT IMPEXT TESTDATE TEST BIN$lNOOvpOfQFWXd2khoT4rbw==$0 TESTPRI T BIN$yjG1szGkRfuWMtJjGeEDIA==$0 TABLE_NAME ------------------------------ TESTCHARCHAR TESTCHARBYTE DUPEMP BIN$2vbDpIPIQc+9a/FiTZK0cg==$0 BIN$qaivnHGGQbG2V87+uvICUg==$0 BIN$d4XzykugS9q6xMpCXf143A==$0 TESTCHAR 18 rows selected. SQL> spool off