다중 insert 시 시퀀스 넘버가 PK 제약조건을 어긋내는 경우 해결방안.

• PK 를 제외한 삽입 컬럼을 dual 테이블에 올리고 UNION ALL로 결합
• 결합한 테이블 로우에 시퀀스 넘버 삽입
• 해당 select 문의 결과를 insert

--다중 인서트 문 
insert into salary 
select salary_seq_sno.nextval , A.* from (
    select '고정급여' as S_TYPE, null as unitprice from dual UNION ALL
    select '성과급' as S_TYPE, null as unitprice from dual UNION ALL
    select '프로모션_급여' as S_TYPE, null as unitprice from dual UNION ALL
    select '조직성과' as S_TYPE, null as unitprice from dual UNION ALL
    select '잔업근무수당' as S_TYPE, null as unitprice from dual UNION ALL
    select '휴일근무수당' as S_TYPE, null as unitprice from dual UNION ALL
    select '연차유급수당' as S_TYPE, 2.1 as unitprice from dual UNION ALL
    select '퇴직충당금' as S_TYPE, 8.33 as unitprice from dual 
) A;