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;

⇒ Categories of Data Types in PL/SQL in Oracle

⇐ Numeric Comparison Operations in Oracle

⇑ Understanding PL/SQL Language Basics

⇑⇑ Oracle Database Tutorials

2018-08-06, 2414🔥, 0💬

Scalar Data Types Supported in PL/SQL in Oracle
How Many Scalar Data Types Are Supported in PL/SQL in Oracle? PL/SQL supports many scalar data types divided into 4 groups: Numeric Types: BINARY_DOUBLE, BINARY_FLOAT, BINARY_INTEGER, DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NATURAL, NATURALN, NUMBER, NUMERIC, PLS_INTEGER, POSITIVE, POSI... 2018-11-17, 2533🔥, 0💬

Logical Operations in PL/SQL in Oracle
What Are the Logical Operations in Oracle? 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; ⇒ Categories of Data Typ... 2018-08-06, 2415🔥, 0💬

Categories of Data Types in PL/SQL in Oracle
How Many Categories of Data Types in Oracle? PL/SQL data types are grouped into 4 categories: Scalar Data Types: A scalar data type holds a single value. Composite Data Types: A composite data type has internal components, such as the elements of an array. LOB Data Types: A LOB data type holds a lob... 2018-11-17, 2413🔥, 0💬

Initialize Variables with Default Values in Oracle
How To Initialize Variables with Default Values in Oracle? There are two ways to assign default values to variables at the time of declaration: Using key word DEFAULT - Appending "DEFAULT value" to the end of declaration statements. Using assignment operator - Appending ":= value" to the end of decl... 2018-08-06, 2407🔥, 0💬

Arithmetic Operations in Pl/SQL in Oracle
What Are the Arithmetic Operations in Oracle? There are 4 basic arithmetic operations on numeric values as shown in the following sample script: PROCEDURE proc_arithmetic AS addition NUMBER; subtraction NUMBER; multiplication NUMBER; division NUMBER; BEGIN addition := 7 + 8; subtraction := addition ... 2018-08-06, 2403🔥, 0💬

Use "IF" Statements with Multiple Conditions in Oracle
How To Use "IF" Statements on Multiple Conditions in Oracle? If you have multiple blocks of codes to be executed based on different conditions, you can use the "IF ... ELSIF" statement. Here is a sample script on IF statements: DECLARE day VARCHAR2; BEGIN day := 'SUNDAY'; IF day = 'THURSDAY' THEN DB... 2018-07-13, 2325🔥, 0💬

Convert Character Types to Numeric Types in Oracle
How To Convert Character Types to Numeric Types in Oracle? You can convert character types to numeric types in two ways: Explicitly by using TO_NUMBER() function. Implicitly by putting character data in a numeric operation. The sample script below shows you how to convert character types to numeric ... 2018-11-17, 2300🔥, 0💬

Numeric Comparison Operations in Oracle
What Are the Numeric Comparison Operations in Oracle? 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... 2018-08-06, 2286🔥, 0💬

Assign Values to Variables in Oracle
How To Assign Values to Variables in Oracle? You can use assignment statements to assign values to variables. An assignment statement contains an assignment operator ":=", which takes the value specified on the right to the variable on left. The script below show you some examples of assignment stat... 2018-08-06, 2139🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.