 |
|
DBMS_CRYPTO package tips
Oracle Tips by Burleson Consulting |
DBMS_CRYPTO
<< Return to the index
Related notes on DBMS_CRYPTO: Oracle 11g provides the following information about the DBMS_CRYPTO package:
Description of the DBMS_CRYPTO package:
FUNCTION DBMS_CRYPTO.DECRYPT RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC RAW IN
TYP BINARY_INTEGER IN
KEY RAW IN
IV RAW IN DEFAULT
PROCEDURE DBMS_CRYPTO.DECRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DST BLOB IN/OUT
SRC BLOB IN
TYP BINARY_INTEGER IN
KEY RAW IN
IV RAW IN DEFAULT
PROCEDURE DBMS_CRYPTO.DECRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DST CLOB IN/OUT
SRC BLOB IN
TYP BINARY_INTEGER IN
KEY RAW IN
IV RAW IN DEFAULT
FUNCTION DBMS_CRYPTO.ENCRYPT RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC RAW IN
TYP BINARY_INTEGER IN
KEY RAW IN
IV RAW IN DEFAULT
PROCEDURE DBMS_CRYPTO.ENCRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DST BLOB IN/OUT
SRC BLOB IN
TYP BINARY_INTEGER IN
KEY RAW IN
IV RAW IN DEFAULT
PROCEDURE DBMS_CRYPTO.ENCRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DST BLOB IN/OUT
SRC CLOB IN
TYP BINARY_INTEGER IN
KEY RAW IN
IV RAW IN DEFAULT
FUNCTION DBMS_CRYPTO.HASH RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC RAW IN
TYP BINARY_INTEGER IN
FUNCTION DBMS_CRYPTO.HASH RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC BLOB IN
TYP BINARY_INTEGER IN
FUNCTION DBMS_CRYPTO.HASH RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC CLOB IN
TYP BINARY_INTEGER IN
FUNCTION DBMS_CRYPTO.MAC RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC RAW IN
TYP BINARY_INTEGER IN
KEY RAW IN
FUNCTION DBMS_CRYPTO.MAC RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC BLOB IN
TYP BINARY_INTEGER IN
KEY RAW IN
FUNCTION DBMS_CRYPTO.MAC RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC CLOB IN
TYP BINARY_INTEGER IN
KEY RAW IN
FUNCTION DBMS_CRYPTO.RANDOMBYTES RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NUMBER_BYTES BINARY_INTEGER IN
FUNCTION DBMS_CRYPTO.RANDOMINTEGER RETURNS BINARY_INTEGER
FUNCTION DBMS_CRYPTO.RANDOMNUMBER RETURNS NUMBER
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|