This content has been marked as final. Show 2 replies
Suppose you have a value which you want to compare is string or number, take that value in varchar2 variable. Then get your retrieved string into VARCHAR2 variable then simply compare it.
It will through no error because both are now string.
Hope you understand.
Since both are varchar2 columns,
SImply try beow..
Let us think that u have two field -Filed1 and Filed2 - both are varchar2 type, then to compare, do below
If Upper(Filed1) = Upper(Filed2) Then
----- Equal -Message