Oracle - Logical Operations in PL/SQL in Oracle

Logical Operations in PL/SQL in Oracle

Q

What Are the Logical Operations in Oracle?

✍: FYIcenter.com

A

PL/SQL supports 3 logical operations as shown in the following sample script:

PROCEDURE proc_comparison AS
  x BOOLEAN := TRUE; 
  y BOOLEAN := FALSE;
  res BOOLEAN; 
BEGIN
  res = x AND y;
  res = x OR y; 
  res = NOT x;
  -- more statements
END;

⇒Understanding PL/SQL Language Basics

⇒⇒Oracle Database Tutorials

2016-10-17, 164👍, 0💬

Popular Posts:

Ending Stored Proced...

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

Error: Imported Tabl...

What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

Define External Tabl...

How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...