Oracle中查看某列数据类型
Oracle中查看某列数据类型
Oracle中查看某列数据类型
select DATA_TYPE from User_Tab_Columns t where t.column_name=upper('column_name')
and T.TABLE_NAME=upper(trim('table_name'));
注意列名和表名要大写
Oracle中查看某列数据类型
select DATA_TYPE from User_Tab_Columns t where t.column_name=upper('column_name')
and T.TABLE_NAME=upper(trim('table_name'));
注意列名和表名要大写
评论暂时关闭