[size=14px][backcolor=inherit][backcolor=rgb(155, 187, 89)][size=22px]查询当前登录连接的用户
[backcolor=inherit][backcolor=rgb(155, 187, 89)]SQL> show user
[backcolor=inherit][backcolor=rgb(155, 187, 89)]USER is “SYS”
[backcolor=inherit][backcolor=rgb(155, 187, 89)]SQL> conn scott/wjvogue
[backcolor=inherit][backcolor=rgb(155, 187, 89)]Connected.
[backcolor=inherit][backcolor=rgb(155, 187, 89)]SQL> show user
[backcolor=inherit][backcolor=rgb(155, 187, 89)]USER is “SCOTT”
[backcolor=inherit][backcolor=rgb(155, 187, 89)]SQL>

[size=14px][backcolor=inherit][backcolor=inherit][backcolor=rgb(250, 192, 143)][size=22px]查询当前用户下的所有数据库表

[backcolor=inherit][size=14px][backcolor=inherit][backcolor=rgb(250, 192, 143)]SQL> show user;
[backcolor=inherit][backcolor=rgb(250, 192, 143)]USER is “SYS”
[backcolor=inherit][backcolor=rgb(250, 192, 143)]SQL> conn scott/wjvogue
[backcolor=inherit][backcolor=rgb(250, 192, 143)]Connected.
[backcolor=inherit][backcolor=rgb(250, 192, 143)]SQL> select table_name from user_tables;
[backcolor=inherit][backcolor=rgb(250, 192, 143)]

[backcolor=inherit][backcolor=rgb(250, 192, 143)]TABLE_NAME
[backcolor=inherit][backcolor=rgb(250, 192, 143)]————————————————————
[backcolor=inherit][backcolor=rgb(250, 192, 143)]DEPT
[backcolor=inherit][backcolor=rgb(250, 192, 143)]EMP
[backcolor=inherit][backcolor=rgb(250, 192, 143)]BONUS
[backcolor=inherit][backcolor=rgb(250, 192, 143)]SALGRADE
[backcolor=inherit][backcolor=rgb(250, 192, 143)]

[backcolor=inherit][backcolor=rgb(250, 192, 143)]SQL>