Hello,
I am new to Oracle and is trying to achieve update cascade. I have read the information that oracle does not have "ON UPDATE" thus i want to know how I can achieve the update cascading on the following example?
Table Student
| Roll_No(Primary key) | Name | Marks |
|---|
| 1 | John | 80 |
| 2 | Harry | 90 |
| 3 | Robin | 70 |
Table Country
| ID | Roll_No(Foreign_key) | Country |
|---|
| 1 | 1 | USA |
| 2 | 2 | USA |
| 3 | 3 | AUS |
1) I am going to update Roll_No from Student and want to update the records in Country. What are the ways to achieve it?