oracle获取表字段属性

select b.COMMENTS,a.COLUMN_NAME,a.DATA_TYPE,a.DATA_LENGTH,
 a.DATA_PRECISION,a.DATA_SCALE,a.NULLABLE,COLUMN_ID
  from user_tab_columns a
   inner join user_col_comments b on b.COLUMN_NAME=a.column_name and b.table_name=a.TABLE_NAME
        where a.table_name =UPPER('表名')