Re: BINARY_CHECKSUM IN ORACLE

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 2 May 2006 14:39:34 -0800
Message-ID: <4457d196$1@news.victoria.tc.ca>

Vinay Bhushan (bhushanvinay_at_gmail.com) wrote:
: hello gents,

: i have a task of porting from sql server to oracle, i am looking for
: help on the following

: IN sql server i write
: -----------
: SELECT BINARY_CHECKSUM ( FIELD_A,FIELD_B,FIELD_C,FIELD_D) AS CHK
: FROM TEST_TABLE
Perhaps MD5 will work well enough. google "Oracle Sql md5" for examples.

You may have to write your own wrapper(s) to make it do exactly what you want.

In your wrapper, to concatenate fields, you should instead loop over them and concatenate the previous checksum each time so (for example) 'h','ello' will checksum differently than 'he','llo'

$0.10 Received on Tue May 02 2006 - 17:39:34 CDT