advanced code snippet search

Posted By

mprabhuram on 08/31/10


Tagged

Oracle


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

AndyF
Tyster


Generate HASH Value for a string

 / Published in: SQL
 

URL: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_util.htm#i1003646

GETHASHVALUE Function

This function computes a hash value for the given string.

Syntax

DBMSUTILITY.GETHASHVALUE ( name VARCHAR2, base NUMBER, hashsize NUMBER) RETURN NUMBER;

Expand | Embed | Plain Text 
  1. SELECT 'HELLO1', dbms_utility.get_hash_value('HELLO6',5,1232312) FROM dual;

Report this snippet  

You need to login to post a comment.