General MySQL Oracle SQL Server

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;

 

⇒ Logical Operations in PL/SQL in Oracle

⇐ Arithmetic Operations in Pl/SQL in Oracle

⇑ Understanding PL/SQL Language Basics

⇑⇑ Oracle Database Tutorials

2018-08-06, 2614🔥, 0💬

General MySQL Oracle SQL Server