sql: SELECT '1'||'2' from dual
结果:12
sql:SELECT NULL||'2' from dual
结果:NULL
所以修正最好这样子拼接,判断是否为空:
sql:SELECT COALESCE(NULL,'')||'2' from dual
结果:2
sql: SELECT '1'||'2' from dual
结果:12
sql:SELECT NULL||'2' from dual
结果:NULL
所以修正最好这样子拼接,判断是否为空:
sql:SELECT COALESCE(NULL,'')||'2' from dual
结果:2