Thursday, 4 October 2012

Lesson : 8 - Operators


The following Oracle operators,
Arithmetic Operators
Comparison Operators
unary       + -
arithmetic  * /
binary      + -
equality       =
inequality     !=, <>
greater        >, >=
less than      <, <=
equal to any   IN, =ANY
not equal to   NOT IN, !=ANY
any            =ANY, !=ANY, >ANY, <="ANY,">=ANY
all            =ALL, !=ALL, >ALL, <="ALL,">=ALL
between        [NOT] BETWEEN x ANY y
exists         EXISTS
like           x [NOT] LIKE y
null            IS [NOT] NULL
Logical Operators
     NOT
     AND
     OR
Character Operators
concatenate ||

No comments:

Post a Comment