1.查看当前用户的表:
SCOTT@orcl>select table_name from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
SALGRADE
USERS
T
EXCEPTIONS
PLAN_TABLE
FLASH_TBL
EMPLOYEE
TEMP
INDEX_TABLE
2 查看当前用户权限:
SCOTT@orcl>select * from session_privs;
PRIVILEGE
----------------------------------------
ALTER SYSTEM
AUDIT SYSTEM
CREATE SESSION
ALTER SESSION
RESTRICTED SESSION
CREATE TABLESPACE
ALTER TABLESPACE
MANAGE TABLESPACE
DROP TABLESPACE
UNLIMITED TABLESPACE
CREATE USER
3. 查看表列上的信息
SELECT * FROM user_tab_columns WHERE table_name='USERS'