title: Update Table with foreign key in oracle 10.2
body: <p>I have one table <code>ROUTE_DETAILS</code> with column <code>ROUTE_NUMBER</code> and <code>ROUTE_NAME</code>.</p>
  
  <p>I have another table <code>CUSTOMER_DETAILS</code> with column <code>CUST_CODE</code>, <code>CUST_NAME</code>, <code>ROUTE_NUMBER</code>. Here route number is the foreign key of <code>ROUTE_DETAILS</code>.</p>
  
  <p><code>ROUTE_DETAILS</code> is parent table and <code>CUSTOMER_DETAILS</code> is child table.</p>
  
  <p>Data in <code>ROUTE_DETAILS</code>: </p>
  
  <pre>
  ROUTE_NUMBER        ROUTE_NAME
  RN0001            ROUTE1
  RN0002            ROUTE2
  RN                ROUTE3
  </pre>
  
  <p>Data in <code>CUSTOMER_DETAILS</code>: </p>
  
  <pre>
  CUST_CODE        CUST_NAME       ROUTE_NUMBER
  CC0001         CUSTOMER1        RN0001
  CC0002         CUSTOMER2        RN
  </pre>
  
  <p>Now the problem is when I am trying to update <code>ROUTE_NUMBER</code> from <code>ROUTE_DETAILS</code> or update <code>ROUTE_NUMBER</code> from <code>CUSTOMER_DETAILS</code> an error is shown: <em>integrity constraints violation child record found</em></p>
  
  <p>Query is: </p>
  
  <pre><code>update ROUTE_DETAILS 
     set ROUTE_NUMBER = 'RN0003' 
   where ROUTE_NUMBER = 'RN'
  </code></pre>
  
  <p>same thing happen when I am trying to update customer_details.</p>