<insert id="insert" parameterClass="map">
//여기 resultClass에 지정된 데이터 타입으로 키 반환..
<selectKey resultClass="String" keyProperty="seq">
SELECT TO_CHAR(NVL(MAX(seq), 0)+1, '00000000') FROM TARGET
</selectKey>
INSERT INTO TARGET ( SEQ, FILED1, FILED2,............... )
VALUES ( #seq#, #field1#, #field2#, ...... )
</insert>
SELECT TO_CHAR(NVL(MAX(seq), 0)+1, '00000000') FROM TARGET
</selectKey>
INSERT INTO TARGET ( SEQ, FILED1, FILED2,............... )
VALUES ( #seq#, #field1#, #field2#, ...... )
</insert>
