CREATE OR REPLACE TRIGGER ti_email_accounts
BEFORE INSERT ON email_accounts
FOR EACH ROW
DECLARE
BEGIN
select email_account_id_seq.NEXTVAL 
INTO :new.email_account_id
FROM dual;
END;
/