create or replace SEQUENCE JS_HEALTH_CHECK_seq start with 1 nocache;
CREATE OR REPLACE TRIGGER JS_HEALTH_CHECK_BIU
before insert OR UPDATE ON JS_HEALTH_CHECK
for each row
BEGIN
IF :NEW.ID IS NULL THEN
SELECT JS_HEALTH_CHECK_seq.nextval INTO :NEW.ID FROM sys.dual;
END IF;
END;
/
Trigger to Assign sequence as PK
Trigger to Assign sequence as PK
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
Who is online
Users browsing this forum: No registered users and 12 guests