Re: Getting long value

From: Oliver Stratmann <stratmo_at_anonymous.de>
Date: Wed, 08 Nov 2006 23:37:55 +0100
Message-ID: <4rf4a9Fr3pf7U1@mid.individual.net>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Eitan M schrieb:
> Hello,
> I want to compare two LONG columns in a specific table (Oracle 8i).
> Maybe by the CRC code for the LONG column.
>
> Is there any function that convert the LONG column to CRC string ?
> Also I want to know which byte makes the difference.
> Is there any other solution for the above ?
>
> Thanks :)
>
>

You may try a kind of Long to Varchar2-conversion. This only works up to 4000 signs.
(It helped me selecting the USER_VIEWS.TEXT quite often;-)

Please have a look at:
http://asktom.oracle.com/pls/ask/f?p=4950:8:11377355620636489482::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:839298816582

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (Cygwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFUlxDS/wzzi1yrp0RApbAAKDRcdAZCPbg1ZqSRkVqa7621RC6OACgsTKJ O/BMzTBqxHlCJKio5R9otVo=
=p12R
-----END PGP SIGNATURE----- Received on Wed Nov 08 2006 - 16:37:55 CST