SERPland Flugverkehr/Airtraffic Zürich – Auto Direktimport Dänemark – Disneyland Paris – Legoland Deutschland


PL/SQL Function Hash Algorithm – Oracle Hash Value


Oracle® Database PL/SQL Function and Packages and Types Reference

For Oracle 10g:

DBMS_CRYPTO provides an interface to encrypt and decrypt stored data, and can be used in conjunction with PL/SQL programs running network communications. It provides support for several industry-standard encryption and hashing algorithms, including the Advanced Encryption Standard (AES) encryption algorithm. AES has been approved by the National Institute of Standards and Technology (NIST) to replace the Data Encryption Standard (DES)



Oracle Cryptographic Toolkit Programmer's Guide

Release 2.0.4:

Section 7.2, "Digital Signature"
the following PL/SQL routines to create and verify digital signatures. There are two versions of each routine: one for raw data and another for strings.
"Sign", "Verify" ,"SignDetached" and  "VerifyDetached"

Section 7.3, "Hash"   – Oracle Hash Value
this pl/sql routines can be used to generate checksums. There are two versions of each routine: one for raw data and another for strings (KeyedHash, Hash)

Section 7.4, "Random Number Generation"



using the Package(DBMS_UTILITY) it contains a
function named (GET_HASH_VALUE) to get Oracle Hash Value


Doing a PL/SQL hash function

using  select ora_hash … from dual

or using  dbms_crypto …

Related Posts:


Toad 9 default options which should be changed

With Toad 9.0 for Oracle, some Toad options do have changed default values against older Toad versions.
To change Toad options in top menu: VIEW - TOAD OPTIONS

I changed following options :

Editor - Display - Hightlight View Names: from unchecked to checked.

Because I like to see View names the same as Table names in a sql statements and pl/sql programs.

Editor - Open/Save - Opening Files: from "prompt to split files" to "never split files".

Because all my sources are saved as files in a filebased source management system. On check out I don't want Toad to split my files.

Related Posts: