ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Apply a supported cryptographic hash function to a SQL statement. This function can not be used to hash a string that is not a valid SQL statement.
AUTHID
CURRENT_USER
Constants
Uses DBMS_CRYPTO constants. See link at page
bottom
Dependencies
DBMS_CRYPTO
DBMS_SQL
UTL_RAW
DBMS_LOB
Documented
No
First Available
12.1
Pragma
PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/dbmsobtk.sql
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;
set serveroutput on
DECLARE
sqlstr VARCHAR2(4000):='SELECT object_name FROM all_objects WHERE rownum = 1';
digtype PLS_INTEGER := 3;
RetVal RAW(2000);
BEGIN
SELECT dbms_sqlhash.gethash(sqlstr, dbms_crypto.hash_sh1)
INTO RetVal
FROM dual;