1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE TABLE "RH_GRADE"
(
"GRADE_ID" NUMBER(*,0) CONSTRAINT "PK_RH_GRADES" NOT NULL ENABLE,
"NAME_FR" VARCHAR2(255 CHAR),
"NAME_NL" VARCHAR2(255 CHAR),
"GLEVEL" VARCHAR2(1 CHAR),
"ACTIVE" VARCHAR2(1 CHAR),
"PCODE" VARCHAR2(10 CHAR),
PRIMARY KEY ("GRADE_ID")
);
CREATE OR REPLACE TRIGGER "RH_GRADE_ID_TRIG" BEFORE
INSERT ON RH_GRADE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN
SELECT NVL(:new.GRADE_Id,RH_GENERIC_SEQ.nextval) INTO :NEW.GRADE_Id FROM DUAL;
END;
/
ALTER TRIGGER "RH_GRADE_ID_TRIG" ENABLE;
CREATE SEQUENCE "RH_GENERIC_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 66363 CACHE 20 NOORDER NOCYCLE ; |