常用sql

/**取得dyzc用户的所有数据库表名、备注*/
select t.table_name as tablename, t1.comments as comments from all_tables t, all_tab_comments t where t1.table_name=

t.table_name and t.owner = 'DYZC' and t1.owner = 'DYZC' order by comments ASC；

/**取得某个表(TABLE1)的所有英文列名、中文注释*/
select t.table_name as tablename, t.column_name as columnname, t.comments as comments, t1.DATA_TYPE as type from

user_col_comments t, user_tab_columns t1  where t.table_name = t1.TABLE_NAME  and t.column_name =t1.COLUMN_NAME  and

t.table_name = 'TABLE1'