Thursday, June 25, 2009

DB tables













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