Foreign key did not update with primary key in oracle -


i'm using oracle 11g r2 express edition , sql command line. i'm getting problem when update primary key foreign key did not update. there solution?

this command 2 table

create table staff(staff_id number(5) not null primary key);  create table customer(customer_id number(5) not null primary key,staff_id number(5) not null references staff); 

what did do? sql statement?

did updated primary key value consistent row in customer table? sure there corresponding row in customer table?


Comments

Popular posts from this blog

android - How to save instance state of selected radiobutton on menu -

python 3 IndexError: list index out of range -

IF statement in MySQL trigger -