select DATA_TYPE from User_Tab_Columns t where t.column_name=upper('column_name')
and T.TABLE_NAME=upper(trim('table_name'));
注意列名和表名要大写
select DATA_TYPE from User_Tab_Columns t where t.column_name=upper('column_name')
and T.TABLE_NAME=upper(trim('table_name'));
注意列名和表名要大写