分页更新
UPDATE KAMS_PRODUCT_PART PP SET( \
PART_NAME, \
PART_CODE, \
NOTE, \
UPDATE_DATE, \
UPDATE_CODE) = ( \
SELECT PART_NAME, \
PART_CODE, \
NOTE, \
UPDATE_DATE, \
UPDATE_CODE \
FROM (SELECT * FROM ( \
SELECT DATA.*, ROWNUM AS ROWNUM_ \
FROM ( SELECT BODYMODEL_CODE, \
BODYMODEL_NO, \
PART_NO, \
PART_NAME, \
PART_CODE, \
NOTE, \
KAMS_NEWPRODUCT_PART.UPDATE_DATE, \
KAMS_NEWPRODUCT_PART.UPDATE_CODE \
FROM KAMS_NEWPRODUCT_PART \
WHERE HANDLE_FLG=1 \
AND DEL_FLG=0 \
AND PRE_PART_NO IS NULL ) DATA ) \
WHERE ROWNUM_ BETWEEN ? AND ? ) NP \
WHERE NP.BODYMODEL_CODE= PP.PRODUCT_MODEL_CD \
AND NP.BODYMODEL_NO= PP.MODEL_NO \
AND NP.PART_NO= PP.PART_NO ) \
WHERE EXISTS (SELECT 1 FROM \
(SELECT * FROM ( \
SELECT DATA.*, ROWNUM AS ROWNUM_ \
FROM ( SELECT BODYMODEL_CODE, \
BODYMODEL_NO, \
PART_NO \
FROM KAMS_NEWPRODUCT_PART \
WHERE HANDLE_FLG=1 \
AND DEL_FLG=0 \
AND PRE_PART_NO IS NULL ) DATA ) \
WHERE ROWNUM_ BETWEEN ? AND ? ) NP \
WHERE NP.BODYMODEL_CODE= PP.PRODUCT_MODEL_CD \
AND NP.BODYMODEL_NO= PP.MODEL_NO \
AND NP.PART_NO= PP.PART_NO ) \
分页插入
insert.005 = \
INSERT INTO KAMS_NEWPRODUCT_ERR \
SELECT KYOTEN_CODE, \
BODYMODEL_CODE, \
BODYMODEL_NAME, \
BODYMODEL_NO, \
ENGINE_NO, \
ENGINEMODEL_CODE, \
ENGINEMODEL_NAME, \
PRODUCE_DATE, \
NYUUKA_DATE, \
WARRANTY_CARD_NO, \
HANDLE_FLG, \
DEL_FLG, \
NOTE, \
PRE_BODYMODEL_CODE, \
PRE_BODYMODEL_NAME, \
PRE_BODYMODEL_NO, \
PRE_ENGINEMODEL_CODE, \
PRE_ENGINEMODEL_NAME, \
PRE_ENGINE_NO, \
INSERT_DATE, \
INSERT_CODE, \
UPDATE_DATE, \
UPDATE_CODE, \
VERSION, \
ERR_MSG \
FROM \
(SELECT DATA.*, ROWNUM AS ROWNUM_ \
FROM ( SELECT \
NP.*, \
NVL((SELECT MAX(VERSION) FROM KAMS_NEWPRODUCT_ERR B WHERE B.KYOTEN_CODE = NP.KYOTEN_CODE \
AND NP.BODYMODEL_CODE = B.BODYMODEL_CODE \
AND NP.BODYMODEL_NO = B.BODYMODEL_NO),0)+1 AS VERSION, \
'{0}' || NP.BODYMODEL_CODE AS ERR_MSG \
FROM KAMS_NEWPRODUCT NP \
WHERE HANDLE_FLG = 0 \
AND DEL_FLG = 0 \
AND NOT EXISTS (SELECT 1 FROM PRODUCT_M WHERE NP.BODYMODEL_CODE = PRODUCT_CODE) ) DATA ) \
WHERE ROWNUM_ BETWEEN ? AND ? \
UPDATE KAMS_PRODUCT_PART PP SET( \
PART_NAME, \
PART_CODE, \
NOTE, \
UPDATE_DATE, \
UPDATE_CODE) = ( \
SELECT PART_NAME, \
PART_CODE, \
NOTE, \
UPDATE_DATE, \
UPDATE_CODE \
FROM (SELECT * FROM ( \
SELECT DATA.*, ROWNUM AS ROWNUM_ \
FROM ( SELECT BODYMODEL_CODE, \
BODYMODEL_NO, \
PART_NO, \
PART_NAME, \
PART_CODE, \
NOTE, \
KAMS_NEWPRODUCT_PART.UPDATE_DATE, \
KAMS_NEWPRODUCT_PART.UPDATE_CODE \
FROM KAMS_NEWPRODUCT_PART \
WHERE HANDLE_FLG=1 \
AND DEL_FLG=0 \
AND PRE_PART_NO IS NULL ) DATA ) \
WHERE ROWNUM_ BETWEEN ? AND ? ) NP \
WHERE NP.BODYMODEL_CODE= PP.PRODUCT_MODEL_CD \
AND NP.BODYMODEL_NO= PP.MODEL_NO \
AND NP.PART_NO= PP.PART_NO ) \
WHERE EXISTS (SELECT 1 FROM \
(SELECT * FROM ( \
SELECT DATA.*, ROWNUM AS ROWNUM_ \
FROM ( SELECT BODYMODEL_CODE, \
BODYMODEL_NO, \
PART_NO \
FROM KAMS_NEWPRODUCT_PART \
WHERE HANDLE_FLG=1 \
AND DEL_FLG=0 \
AND PRE_PART_NO IS NULL ) DATA ) \
WHERE ROWNUM_ BETWEEN ? AND ? ) NP \
WHERE NP.BODYMODEL_CODE= PP.PRODUCT_MODEL_CD \
AND NP.BODYMODEL_NO= PP.MODEL_NO \
AND NP.PART_NO= PP.PART_NO ) \
分页插入
insert.005 = \
INSERT INTO KAMS_NEWPRODUCT_ERR \
SELECT KYOTEN_CODE, \
BODYMODEL_CODE, \
BODYMODEL_NAME, \
BODYMODEL_NO, \
ENGINE_NO, \
ENGINEMODEL_CODE, \
ENGINEMODEL_NAME, \
PRODUCE_DATE, \
NYUUKA_DATE, \
WARRANTY_CARD_NO, \
HANDLE_FLG, \
DEL_FLG, \
NOTE, \
PRE_BODYMODEL_CODE, \
PRE_BODYMODEL_NAME, \
PRE_BODYMODEL_NO, \
PRE_ENGINEMODEL_CODE, \
PRE_ENGINEMODEL_NAME, \
PRE_ENGINE_NO, \
INSERT_DATE, \
INSERT_CODE, \
UPDATE_DATE, \
UPDATE_CODE, \
VERSION, \
ERR_MSG \
FROM \
(SELECT DATA.*, ROWNUM AS ROWNUM_ \
FROM ( SELECT \
NP.*, \
NVL((SELECT MAX(VERSION) FROM KAMS_NEWPRODUCT_ERR B WHERE B.KYOTEN_CODE = NP.KYOTEN_CODE \
AND NP.BODYMODEL_CODE = B.BODYMODEL_CODE \
AND NP.BODYMODEL_NO = B.BODYMODEL_NO),0)+1 AS VERSION, \
'{0}' || NP.BODYMODEL_CODE AS ERR_MSG \
FROM KAMS_NEWPRODUCT NP \
WHERE HANDLE_FLG = 0 \
AND DEL_FLG = 0 \
AND NOT EXISTS (SELECT 1 FROM PRODUCT_M WHERE NP.BODYMODEL_CODE = PRODUCT_CODE) ) DATA ) \
WHERE ROWNUM_ BETWEEN ? AND ? \