Oracle 9i Fundamentals I Exam Cram 2

Comparison conditions:

• Equi (=), Anti (!=, <>, ^=), and Range (<, >, =<, >=).

• [NOT] LIKEPattern matching.

• [NOT] INSet membership between expressions.

• [NOT] EXISTSSet membership producing a Boolean result.

• [NOT] BETWEENRange search between two values, inclusive of end points.

• ANY, SOME, and ALLSet membership conditions.

  • IS [NOT] NULLNULL value testcondition.

Logical conditions, in order of precedence:

• NOTAn expression being false yields true.

• ANDTwo expressions being true yield true.

• OROne of two expressions being true yields true.