Constrain with cascade for foreign key(S)
select SVR_TASR_SEQ.nextval into :new.TASR_ID from dual;
select SVR_SITR_SEQ.nextval into :new.SITR_ID from dual;
select SVR_ROOR_SEQ.nextval into :new.ROOR_ID from dual;
select SVR_DEVN_SEQ.nextval into :new.DEVN_ID from dual;
select SVR_DEV_SEQ.nextval into :new.DEV_ID from dual;
Steps TABLE, SEQUENCE, TRIGGER
Constraint: Primary, Foreign
No comments:
Post a Comment