Re: NEWBIE: Autonumber trigger

> Does anyone have a simple trigger to emulate the AutoNumber
> function in Access?

Yup, a trigger is the right solution. I think using a procedure as suggested by Fred is a bit to much for a simple insert.

First you create a sequence (an object that in general just keeps a number and increases it on demand), e.g.

CREATE SEQUENCE SEQ_TEST MINVALUE 1 MAXVALUE 99999999999 INCREMENT BY 1 START WITH 0 CACHE 20 NOORDER CYCLE; A Trigger fitting this sequence would look like this...

CREATE OR REPLACE TRIGGER TRG_PK_TEST
BEFORE INSERT ON TEST
FOR EACH ROW
BEGIN
    SELECT
        SEQ_TEST.NEXTVAL into :NEW.TEST_ID     FROM
        DUAL;
END; Regards,

Thomas Bierhance Received on Tue May 25 1999 - 16:55:45 CDT