查看oracle表中列的数据类型
select * from cols
WHERE TABLE_name=upper('table_name');
union oracle报错,比较字符集转换
cast(U . ACCOUNT as NVARCHAR2(40)) 字符集转换
sqlserver
------查询一个表的所有列名,数据类型 select column_name,data_type from information_schema.columns where table_name = 'Sys_User'