NOT can be used by itself or in combination with AND or OR. NOT AND returns all rows except where all the conditions are met; NOT OR returns all rows except where any of the conditions are met.
To create a negating condition:
About conditions (Query Builder)
Adding conditions to a query (Query Builder)
Condition syntax (Query Builder)
Controlling join conditions in linked queries (Query Builder)
Creating a nested condition (Query Builder)
Pasting a function (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.