title: Update all foreign key references
body: <p>I have a table student (id, name, address), and student.id reference in few other tables. Lets assume the id is 120 and this id have several other entries in different tables.</p>
  
  <p>Now i want to update the id value to 130 along with all the foreign key references.</p>
  
  <p>One approach I am thinking of a PL/SQL way - doing a metadata query in <strong>all_constraints</strong> table and find the fk reference tables and then run query into all of them for student_id = 130, then update them. Is there any other better options?</p>