Oracle - Numeric Comparison Operations in Oracle

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

2018-08-06, 382👍, 0💬

Popular Posts:

SQL Server Transact-...

Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...

MySQL Database Tutor...

Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...

EXECUTE - Executing ...

How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

sys.sql_modules - Ge...

How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...