28.23 IS_EQUAL Function

This function returns TRUE if both values are equal and FALSE if not. If both values are NULL, TRUE is returned.

Syntax

APEX_PLUGIN_UTIL.IS_EQUAL (
    p_value1 IN VARCHAR2
    p_value2 IN VARCHAR2)
RETURN BOOLEAN;

Parameters

Table 28-32 IS_EQUAL Parameters

Parameter	Description
`p_value1`	First value to compare.
`p_value2`	Second value to compare.

Return

Table 28-33 IS_EQUAL Return

Return	Description
`BOOLEAN`	Returns `TRUE` if both values are equal or both values are `NULL`, otherwise it returns `FALSE`.

Example

In the following example, if the value in the database is different from what is entered, the code in the if statement is executed.

if NOT apex_plugin_util.is_equal(l_database_value, l_current_value) then
    -- value has changed, do something
    null;
end if;

Parent topic: APEX_PLUGIN_UTIL