We have on delete cascade in Oracle but we don’t have on update cascade. If you compare Oracle with SQL Server in SQL Server we have the option called on update cascade but In Oracle we don’t have this option why? Please can you just clarify my doubt?

  • Interview Candidate
  • 3
  • 3975

Showing Answers 1 - 3 of 3 Answers

jamesravid

  • Dec 12th, 2006
 

There is no "update cascade" functionality in oracle. But you can develop your own code to achieve this. The source code is also available in this urlhttp://asktom.oracle.com/tkyte/update_cascade/index.html

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions