oracle8.1.6 insert into ttl_assignments (user_id, ticket_id) select :user_id, :ticket_id from dual where not exists (select 1 from ttl_assignments where user_id = :user_id and ticket_id = :ticket_id)