PL_SQL中存储过程的问题,请高手帮忙...
我在存储过程中只接写如下的SQL语句,但编译不通过,是因为其中有CASE等关键字,请问我该怎么样改?(这个句子直接执行可以,可写在存储过程中不行.)
INSERT INTO TPSYOKAIDATLT (
HATUBAI,
CENCD,
YOYAKU_Y2,
JIDO_Y3,
YOYAKU_Y3,
JIDO_Y4,
YOYAKU_Y4,
JIDO_Y5,
YOYAKU_Y5 )
SELECT HATUBAI,
ZAICENCD,
NAIBUSCD,
JANCD,
SYUBETSU,
'0',
'0',
( CASE WHEN ZAILEV <> '3' AND FCCD = '1' THEN SURYO ELSE NULL END ),
( CASE WHEN ZAILEV = '3' AND FCCD = '1' THEN SURYO ELSE NULL END ),
( CASE WHEN ZAILEV <> '3' AND FCCD = '2' THEN SURYO ELSE NULL END ),
( CASE WHEN ZAILEV = '3' AND FCCD = '2' THEN SURYO ELSE NULL END ),
'0',
'0',
'0',
'0',
'
'0',
'0'
FROM TPSYOKAIDATT ;