betweenGo

Oracle Triggers

by on Jan.05, 2007, under Oracle

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


Share

Related posts:

  1. Sequences on Oracle
  2. Calling Oracle Stored Procedures and Functions
  3. Changing a user’s password
  4. Describing Tables and Constraints in Oracle
  5. Ruby on Rails and Oracle

:

Leave a Reply

 

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!