The Library is currently in the process of being upgraded from Oracle Database Version 18.104.22.168 to 22.214.171.124.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
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.
Constants (uses DBMS_CRYPTO constants also listed here)
HASH_MD4 (128 bit hash)
HASH_MD5 (128 bit hash)
HASH_SH1 (160 bit hash)
Owned by SYS with no privileges granted
Provides an interface to generate the hash value of the result set returned by a SQL query
sqltext IN VARCHAR2, -- input sql statement
digest_type IN BINARY_INTEGER, -- digest algorithm type
chunk_size IN NUMBER DEFAULT 134217728) -- 128M
set serveroutput on
sqlstr VARCHAR2(4000):='SELECT object_name FROM all_objects WHERE rownum = 1';
digtype PLS_INTEGER := 3;
SELECT dbms_sqlhash.gethash(sqlstr, dbms_crypto.hash_sh1)