查询表结构信息

--查询表结构
select data_type,column_name,data_Comment from user_tab_columns where table_name='BAS_ACCOUNTBASIC';

--查询表注释
select * from
user_tab_Comments t
where table_name='BAS_ACCOUNTBASIC';

--查询列注释
select * from
user_col_Comments t
where table_name='BAS_ACCOUNTBASIC';

--查询一个表的结构信息
select t.table_name,t.comments,t1.column_name,t1.data_type,t2.comments from
  user_tab_Comments t,
  user_tab_columns t1,
  user_col_Comments t2
  where t.table_name=t1.TABLE_NAME
  and t1.TABLE_NAME=t2.table_name
  and t1.COLUMN_NAME=t2.column_name
  and t.table_name='BAS_ACCOUNTBASIC';