PL/SQL supports 6 basic numeric comparison operations as shown in the following sample script:

PROCEDURE proc_comparison AS

res BOOLEAN;

BEGIN

res := 1 = 2;

res := 1 < 2;

res := 1 > 2;

res := 1 <= 2;

res := 1 >= 2;

res := 1 <> 2;

-- more statements

END;