Re: BINARY_CHECKSUM IN ORACLE

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 02 May 2006 11:06:57 -0700
Message-ID: <1146593223.671232@jetspin.drizzle.com>

Vinay Bhushan 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
>
> -------------
>
> i dont have a function which is equivalent to binary_checksum. can i
> have this in any other way.
> this is to uniquely identify a record.

Assuming 10g:

SELECT ora_hash(value)
FROM dual;

Daniel A. Morgan
www.psoug.org Received on Tue May 02 2006 - 13:06:57 CDT