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:


Calculate next (this) friday date with pl/sql – hide out!

Today I needed a PL/SQL funtion to determine next friday's date.
Therefore I had to write a strange PL/SQL function. I'm kind of mixed up - am I complicated?

I'm sure there's a pretty simple Oracle solution out there - hide out!

Hopefully Steven Feuerstein never sees this lines of code. Maybe someon has a better idea than this ....

Related Posts:


Decorator Design Pattern in Oracle PL/SQL: Using Object Type with Constructor

As I did with the Template Method Design Pattern I also tried to implement the "Decorator" Design Pattern in Oracle's PL/SQL language.

English Deutsch/German

The Book "Head First - Design Patterns" perfectly describes the Decorator pattern.
So I wrote some Object Type to implement the Decorator. I'd like to have a DRINK class (Espresso or Tea) with just one attribute called "description" and a method which returns the price.

There are some specific classes to make instances like an Espresso. Other classes are "adding" sugar or cream to my espresso.
I'd like to receive following result:

-- start with a Espresso --
descr= Espresso
price= 1
descr= Espresso, sugar
price= 1,2
descr= Espresso, sugar, Cream
price= 1,95

-- start with a Tea --
descr= Tea
price= 3
descr= Tea, sugar
price= 3,2
descr= Tea, sugar, Cream
price= 3,95

Related Posts: