Oracle Union操作时表结构字段类型不一致查询语句 -ORA-01790: expression must have same datatype as corresponding exp
Oracle union操作时字段类型不一致会报如下错误
--> ORA-01790: expression must have same datatype as corresponding expression
select * from (
SELECT table_name, column_name, data_type,DATA_LENGTH,COLUMN_ID FROM USER_TAB_COLUMNS WHERE table_name =upper('bb_sjb')
UNION
SELECT table_name, column_name, data_type,DATA_LENGTH,COLUMN_ID FROM USER_TAB_COLUMNS WHERE table_name =upper('bb_yzb')
UNION
SELECT table_name, column_name, data_type,DATA_LENGTH,COLUMN_ID FROM USER_TAB_COLUMNS WHERE table_name =upper('bb_zcpgb')
UNION
SELECT table_name, column_name, data_type,DATA_LENGTH,COLUMN_ID FROM USER_TAB_COLUMNS WHERE table_name =upper('bb_hbsjb')
UNION
SELECT table_name, column_name, data_type,DATA_LENGTH,COLUMN_ID FROM USER_TAB_COLUMNS WHERE table_name =upper('bb_bbqtb')
) WHERE COLUMN_NAME IN('ZCZE','XSSR','YYSR')
本文来自博客园,作者:IT情深,转载请注明原文链接:https://www.cnblogs.com/wh445306/p/16751873.html