Query expressions can be combined with AND, OR, and NOT operators. Parentheses can be used to affect grouping. NOT has the highest precedence, AND the next highest precedence, and OR has the lowest precedence. For example, this expression:

name = "joe" OR NOT phone ENDS WITH "7" AND age > 30

is grouped as follows:

(name = "joe" OR ((NOT phone ENDS WITH "7") AND age > 30))


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices