SELECT NVL(COLUMN1,'') || NVL(COLUMN2,'') AS TEST from TABLE1 转载于:https://www.cnblogs.com/FInerProgrammer/p/7150898.html