Creation

CREATE TRIGGER trig_frank
    BEFORE INSERT ON table_frank
    FOR EACH ROW
    BEGIN
        SELECT seq_frank.nextval
        INTO :new.id
        FROM dual;
    END;
.
RUN;

References

• Oracle/PLSQL Topics: Creating Triggers
• Constraints and Triggers in Oracle