原文:http://dbsnake.com/2009/04/index-on-long-text.html
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc dbms_utility
FUNCTION GET_HASH_VALUE RETURNS NUMBER
参数名称 类型 输入/输出默认值?
--------------------------- ----------------------- ------ --------
NAME VARCHAR2 IN
BASE NUMBER IN
HASH_SIZE NUMBER IN
SQL> select DBMS_UTILITY.GET_HASH_VALUE('中科软科技股份有限公司', 1, 16777216) hashvalue
2 from dual;
HASHVALUE
----------
12555097