ORACLE 分页更新 分页插入

分页更新
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 ? \