Numeric Comparison Operations in Oracle

Q

What Are the Numeric Comparison Operations in Oracle?

✍: FYIcenter.com

A

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;

 

Understanding PL/SQL Language Basics

⇒⇒Oracle Database Tutorials

2016-10-17, 199👍, 0💬