CREATE TRIGGER identity_contas BEFORE INSERT ON CONTAS_BANCARIAS
FOR EACH ROW
WHEN (new.ID IS NULL )
BEGIN
    SELECT CONTAS_PAGAR_SEQ.NEXTVAL INTO :new.ID FROM DUAL;
END;