Re: BINARY_CHECKSUM IN ORACLE

"Vinay Bhushan" <bhushanvinay_at_gmail.com> wrote in message news:1146658446.381541.114420_at_y43g2000cwc.googlegroups.com...
> The reason why its a binary check sum is to hold a logical key to the
> position, if a accounting data refresh happens and a position doesnot
> change then we dont calculate or change other data accordingly hence we
> calculate a checksum for fields like accountid, price, date and other
> data in it which helps us to identify the position uniquely.

How about creating a trigger for each row that will recalculate dependent data when the row changes? Or am I missing something?

>
> is there any reason why oracle doesnot provide a binary_checksum
> function. may be the question is too much to think about all i want is
> to calculate the binary checsum at EOD.

Well, probably because they provide all too many other features and overlooked this one or thought that those in need of it will code it themselves (then they realised there is need and created OWA_OPT_LOCK package.) Besides, in Oracle writers do not block readers so if someone locks a row for update this doesn't prevent others from reading it - only from changing it. OWA_OPT_LOCK is mainly for web applications, which do not keep sessions open between calls and thus can't use traditional locking mechanism.

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com