René Nyffenegger's collection of things on the web  
René Nyffenegger on Oracle  Most wanted  Feedback
 Follow @renenyffenegger

where clause [Oracle SQL]  
where condition Types of conditionsComparisonFloating pointLogicalModelMultisetnestedtable is a set nestedtable is not a set nestedtable is a empty nestedtable is not a empty nestedtable member of nestedtable2 nestedtable not member of nestedtable2 nestedtable submultiset of nestedtable2 nestedtable not submultiset of nestedtable2 Pattern matching
See like and regexp_like
Rangeexpr between expr1 and expr2 expr not between expr1 and expr2
See also between.
Nullexpr is null expr is not null XML
equals_path and under_path... needs to be finished ...
Compound(condition) not condition condition1 and condition2 condition1 or condition2 Existsexists (subquery) Inexpr in (expr1, expr2,... exprn) expr not in (expr1, expr2,... exprn) expr in (subquery) expr not in (subquery) (expr1, expr2.... exprn) in (expra, exprb,... exprq) (expr1, expr2.... exprn) not in (expra, exprb,... exprq) (expr1, expr2.... exprn) in (subquery) (expr1, expr2.... exprn) not in (subquery)
exprx can also be of the form
(a,b,...d) :
Is of typeexpr is of (typename) expr is of (typename, typename2...) expr is not of (typename) expr is not of (typename, typename2...) expr is of (typename) expr is of (typename, typename2...) expr is not of (only typename) expr is not of (only typename, typename2...) Appearance
The whereclause appears as part in the merge SQL statement.
