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? -- //www.freelists.org/webpage/oracle-l