//CREATE SEQUENCE IN ORACLE
CREATE SEQUENCE RCT.RCT_EXTRA_SEQ
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999999999999999999
NOCACHE
CYCLE
NOORDER
//CREATE TRIGGER IN ORACLE
CREATE OR REPLACE TRIGGER TGR_SEQ_NAME
// TGR_SEQ_NAME IS YOUR TRIGGER NAME
BEFORE INSERT ON TABIL_NAME
FOR EACH ROW
BEGIN
SELECT SEQ_NAME.NEXTVAL
INTO :new.COLUMN_NAME
FROM dual;
END;
/
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন