Operators : Operators « PL SQL Operators « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Operators
  3. Operators

PL/SQL operators are either unary or binary.

Binary operators act on two values.

An example of binary operators is the addition operator, which adds two numbers together.

Unary operators only operate on one value.

The negation operator is unary.

PL/SQL operators can be divided into the following categories:

  1. Arithmetic operators
  2. Comparison operators
  3. Logical operators
  4. String operators








23.1.Operators
23.1.1.Operators
23.1.2.The basic arithmetic operators in action
23.1.3.Logical Operators in PL/SQL
23.1.4.Running Anonymous Blocks of Code
23.1.5.Arithmetic Operators
23.1.6.Exponentiation
23.1.7.The negation and identity operators in action.
23.1.8.Comparison Operators
23.1.9.The Relational Operators: =, <>, !=, ~=, <, >, <=, >=
23.1.10.Logical Operators
23.1.11.String Operators
23.1.12.Use of Comparison Operators with Strings