INSERT INTO FOO (
	ID
	, NAME
)
SELECT
	MY_SEQUENCE.nextval
	, 'BAR'
FROM
	dual
	left join FOO on
		FOO.NAME = 'BAR'
WHERE
	FOO.ID is null
;