PL/SQL - Operators


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

Arithmetic Operators

  • +
  • -
  • *
  • /
  • **

Relational Operators

  • =
  • !=
  • <>
  • ~=
  • >
  • <
  • >=
  • <=

Comparison Operators

  • LIKE
  • BETWEEN
  • IN
  • IS NULL

Logical Operators

  • AND
  • OR
  • NOT

Operator Precedence

OperatorOperation
**exponentiation
+, -identity, negation
*, /multiplication, division
+, -, ||addition, subtraction, concatenation
=, <, >, <=, >=, <>, !=, ~=, ^=,
IS NULL, LIKE, BETWEEN, IN
comparison
NOTlogical negation
ANDconjunction
ORinclusion

*/

No comments:

Post a Comment