修改如下:但好像最后少了一个括号.
WHERE (CarNum,Repair) IN
(SELECT a.CarNum,a.Repair
FROM RWCARBASE, TMPUPREPAIRREC a
WHERE a.CARNUM = RWCARBASE.NUM AND RWCARBASE.RepairType = 0));
WHERE (CarNum,Repair) IN
(SELECT a.CarNum,a.Repair
FROM RWCARBASE, TMPUPREPAIRREC a
WHERE a.CARNUM = RWCARBASE.NUM AND RWCARBASE.RepairType = 0));
(SELECT a.CarNum || a.Repair
FROM RWCARBASE, TMPUPREPAIRREC a
WHERE a.CARNUM = RWCARBASE.NUM AND RWCARBASE.RepairType = 0);以上语句不要用“||”号,其中一个出现空也成立。
SELECT ADD_MONTHS(Trunc(a.RepairDate, 'dd'), 24)
FROM TmpUprepairRec a
WHERE a.CarNum = TmpUpRepairRec.CarNum AND a.Repair = '2.2.5'就是这条,如果用了SQL语句就不能通过,如换了常量,函数都正确!
我在www.cnoug.ora中也发过类似的帖子,你可以去看看,上次我也是修改了自己的语句。
str:='update......';
execute immediate str;