oracle中的取表信息，主键，comment

Select b.COMMENTS, a.COLUMN_NAME, a.DATA_TYPE,a.DATA_LENGTH, a.NULLABLE,
a.COLUMN_ID, a.DATA_PRECISION, a.DATA_SCALE
From USER_TAB_COLS a,USER_COL_COMMENTS b
where a.TABLE_NAME = b.TABLE_NAME
And a.COLUMN_NAME = b.COLUMN_NAME And a.TABLE_NAME = upper('T_WB') Order By a.COLUMN_ID

 

Select b.COLUMN_NAME
From user_constraints a,user_cons_columns b
Where a.constraint_name = b.constraint_name
And a.table_name = upper('T_WB') And a.constraint_type = 'P'

 

Select COMMENTS, TABLE_NAME
From USER_TAB_COMMENTS
Where comments Is Not Null