$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << Oracle DBMS_SQLHASH Version 11.1  
General Information
Source {ORACLE_HOME}/rdbms/admin/dbmsobtk.sql
Digest Types (DBMS_CRYPTO)
Digest Type Data Type Value
HASH_MD4 BINARY_INTEGER 1
HASH_MD5 BINARY_INTEGER 2
HASH_SH1 BINARY_INTEGER 3
Dependent Objects
DBMS_CRYPTO DBMS_SQL
DBMS_LOB UTL_RAW
 
GETHASH

Provides an interface to generate the hash value of the result set returned by a SQL query
dbms_sqlhash.gethash(
sqltext     IN VARCHAR2,                 -- input sql statement
digest_type IN BINARY_INTEGER,           -- digest algorithm type
chunk_size  IN NUMBER DEFAULT 134217728) -- 128M
RETURN RAW;
-- To create the all_objs table: Click Here

set serveroutput on

DECLARE
 sqlstr VARCHAR2(4000):='SELECT object_name FROM all_objs WHERE rownum = 1';
 digtype PLS_INTEGER := 3;
 RetVal  RAW(2000);
BEGIN
  SELECT dbms_sqlhash.gethash(sqlstr, dbms_crypto.hash_sh1)
  INTO RetVal
  FROM dual;

  dbms_output.put_line(RetVal);
END;
/
 
Related Topics
DBMS_CRYPTO
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>