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

2016-10-17, 303👍, 0💬

Popular Posts:

CHARINDEX() and SUBS...

How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...

Generating CREATE VI...

How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...

CHAR(n) - Truncating...

How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...

What Is SQL in MySQL...

What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...

Ending Stored Proced...

How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...