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

Table24.55.Errors signalled by

SQLState Error Code Error Text Description

Examples

Example24.216.Simple example

SQL> select md5 ('blah blah');
callret
VARCHAR
_______________________________________________________________________________

ae661d08d1ca1576a6efcb82b7bc502f

1 Rows. -- 4 msec.


See Also

RFC1321