Name
md5 — returns the md5 checksum of its argument
Synopsis
checksum
md5
(
|
in
str
varchar
); |
Description
md5
calculates the MD5 checksum of its argument.
The md5 message digest algorithm is defined in
RFC1321
.
Parameters
str
A string or string_output containing the data for calculating the message digest.
Return Types
A string of 32 lowercase alphanumeric characters.
Errors
Table 24.54. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
Examples
Example 24.216. Simple example
SQL> select md5 ('blah blah');
callret
VARCHAR
_______________________________________________________________________________
ae661d08d1ca1576a6efcb82b7bc502f
1 Rows. -- 4 msec.