[Oracle] 조건 맞을때만 insert 하기

INSERT INTO member_info (

mi_num,

mi_user_id,

mi_part_id,

mi_delyn,

mi_cre_date

) SELECT

'115164',

'12',

'12',

'N',

'20170123011011'

FROM

dual

WHERE

1 = 1

AND NOT

EXISTS (

    SELECT

        mi_num,

        mi_user_id

    FROM

        member_info

    WHERE

        1 = 1

    AND

        mi_num = '115164'

    AND

        mi_user_id = '12'

);