Table subject -> sub_code(primary key), sub_name, faculty
Table student -> student_id(primary key), student_name, sub_code, sub_name
Query: Update student Set student_id=11 Where student_id=10
Getting error because of foreign key
Asked
Active
Viewed 15 times
0
-
Also update the primary key in table 'subject'. – lsanchezo Jul 12 '22 at 14:45
-
An example with deferrable constraints [db<>fiddle](https://dbfiddle.uk/?rdbms=oracle_21&fiddle=47cb1f73e6aa5e2ae55901436c2a7b8e) – MT0 Jul 12 '22 at 15:30