[mapper] xml에서 PLSQL 쿼리 작성법

    <!-- 주석 -->
    <insert id="admin">
        /* AdminMapper.admin */
        {
            CALL
            DECLARE
            BEGIN
                -- MERGE
                MERGE
                INTO a
                USING b
                ON (a.CODE = b.CODE)
                WHEN MATCHED THEN
                    UPDATE
                    SET a.NAME = b.NAME
                WHEN NOT MATCHED THEN
                    INSERT (SEQ, CODE, NAME)
                    VALUES (SEQ.NEXTVAL, b.CODE, b.NAME);

                LOOP
					...
                END LOOP;
            END
        }
    </insert>