MD5_CHECKSUM Function

This function passes values to HTMLDB_ITEM.MULTI_ROW_UPDATE and is used for lost update detection. Lost update detection ensures data integrity in applications where data can be accessed concurrently.

Syntax

HTMLDB_ITEM.MD5_CHECKSUM(
    p_value01   IN    VARCHAR2 DEFAULT,
    p_value02   IN    VARCHAR2 DEFAULT,
    p_value03   IN    VARCHAR2 DEFAULT,
    ...
    p_value50   IN    VARCHAR2 DEFAULT,
    p_col_sep   IN    VARCHAR2 DEFAULT)
    RETURN VARCHAR2;

Parameters

Table: MD5_CHECKSUM Parameters describes the parameters available in the MD5_CHECKSUM function.

MD5_CHECKSUM Parameters

Parameter Description

Parameter	Description
`p_value01` ... `p_value50`	Fifty available inputs. If no parameters are supplied, the default to null
`p_col_sep`	String used to separate `p_value` inputs. Defaults to the pipe symbol (\|)

p_value01

...

p_value50

Fifty available inputs. If no parameters are supplied, the default to null

p_col_sep

String used to separate p_value inputs. Defaults to the pipe symbol (|)

Example

SELECT HTMLDB_ITEM.MD5_CHECKSUM(ename,job,sal)
FROM emp