create or replace trigger advice_ins_trg before insert on advice for each row
begin
select advice_id_seq.nextval into :NEW.ID FROM DUAL;
begin
select advice_id_seq.nextval into :NEW.ID FROM DUAL;
END;