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 19-30 describes the parameters available in the IS_EQUAL function.

---

Table 19-30 IS_EQUAL Parameters

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

---

Return

Table 19-31 describes the return value by the function IS_EQUAL.

---

Table 19-31 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;