CREATE OR REPLACE TRIGGER ti_email_addresses
BEFORE INSERT ON email_addresses
FOR EACH ROW
DECLARE
BEGIN
select email_address_id_seq.NEXTVAL 
INTO :new.email_address_id
FROM dual;
END;
/