Oracle Triggers

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


Leave a Reply

Your email address will not be published. Required fields are marked *