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

5Jul/110

PL/SQL Function Hash Algorithm – Oracle Hash Value

DBMS_CRYPTO

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

For Oracle 10g: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm

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)

Source: oracle.com

 

Oracle Cryptographic Toolkit Programmer's Guide

Release 2.0.4: http://download.oracle.com/docs/cd/A58617_01/network.804/a54082/ch7plsql.htm

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"

 

DBMS_UTILITY

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

http://oradbpedia.com/wiki/DBMS_UTILITY.GET_HASH_VALUE

 

Doing a PL/SQL hash function

http://stackoverflow.com/questions/5595774/is-there-any-hash-function-in-pl-sql

using  select ora_hash … from dual

or using  dbms_crypto …

Related Posts:

16Oct/06Off

SQL: Remove Strings or Letters


Remove:

select TRANSLATE('12A3','0123456789', ' ') FROM dual

or

 

select
LTRIM(RTRIM(TRANSLATE(UPPER('12a'), ABCDEFGHIJKLMNOPQRSTUVWXYZ', ' '))) as nr
, LTRIM(RTRIM(TRANSLATE(UPPER('12a'),'0123456789', ' '))) as nr_add
from dual

 

 

Related Posts: