Logical Operators - NOT Operator

The Oracle engine will process all rows in a table and display the result only when row of the conditions specified using the NOT operator are satisfied.

Example: Retrieve specified client information for the clients who are NOT in "Hyderabad" OR "Bangalore".

SELECT client_no,name,address1,address2,city,pincode FROM client_master WHERE NOT ( city='Hyderabad' or city='Bangalore');

The oracle engine will not display the rows from the client_master table where the value of the field city is either Hyderabad or Bangalore.

No comments: