常用系统sql整理

--1.查看所有用户

select username from dba_users;

--2.查询数据库表名列注释

select a.TABLE_NAME ,
  b.COMMENTS TABLE_NAME_comments ,
  a.COLUMN_NAME,
  a.comments column_name_comments
FROM user_col_comments a,
  user_tab_comments b
WHERE a.table_name=b.table_name
ORDER BY table_name;