How to check if index was updated?

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 26 Apr 2006 15:42:27 -0400

Got a query from my developers, they are trying to use the
"update xxx set row " syntax to modify a row using a record.

How would I verify that pk index will not get updated if only non
indexed columns were changed in the record?

is there an easy way? btw this is on 10104.

TIA
Rjamya
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l


Other related posts: