利用DBMS_UTILITY.GET_HASH_VALUE 给文本建立索引

原文：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