oracle-2

1. 查看当前用户
select user from dual;
select * from user_users;

2. 查看当前用户拥有的角色和权限：
select * from user_role_privs;
select * from session_privs;

3. 查看表注释
select   tab.*  from  user_tab_comments  tab where tab.table_name= 'test';

4. 查看字段注释
select   col.*  from user_col_comments col where col.table_name ='test' ;

5. 查看表结构
desc test；