Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to check if index was updated?

How to check if index was updated?

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 26 Apr 2006 15:42:27 -0400
Message-ID: <9177895d0604261242yc5a52eaw8d30cca4c4bac453@mail.gmail.com>


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
Received on Wed Apr 26 2006 - 14:42:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US