SELECT table_name, column_name, data_type, data_length, data_precision,
       data_scale, nullable
  FROM user_tab_columns
 WHERE column_name = :name

select data_type
  from user_tab_columns
 where table_name = upper('表名')
   and column_name = upper('字段名')