BINARY_CHECKSUM IN ORACLE

#11

"Vinay Bhushan" <bhushanvinay (AT) gmail (DOT) com> wrote

Quote:

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?

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

BINARY_CHECKSUM IN ORACLE

comp.databases.oracle.misc comp.databases.oracle.misc

Re: BINARY_CHECKSUM IN ORACLE - 05-03-2006 , 08:41 AM