Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora_hash - Same hash value for different inputs (Urgent)

PinokiAug 21 2013 — edited Aug 26 2013

Hi,

Trying to use ora_hash to join between tables but i noticed that in some cases, when working on different input value the ora_hash function generates same results.

select ora_hash('oomeroe03|6NU3|LS006P|7884|1|17-JUL-13 13.18.22.528000|0005043|'),ora_hash('GSAHFFXTK|GCQ3|A6253S|12765|1|17-JUL-13 17.26.26.853000|0136423|')

from dual

Output value : 1387341941

Oracle version is 11gR2.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2013

Added on Aug 21 2013

#general-database-discussions

5 comments

1,925 views