使用union all时,二个表或多个表对应的字段类型要一致,或字符串长度,不一致时必须做转换 拼接的 (select gysid as ckjgid, to_char(gysmc) as jgmc, to_char(GYSJC) jgmcjp, null ckzgjg,null px,null lv from jc_wl_gys) 解决办法:统一用to_char() 做字符型转换