Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle ANY Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: ANY

Definition:
The ANY keyword specifies that the search condition will be TRUE if the comparison is TRUE for at least one of the values that is returned. If not, or if no value is returned, the search condition is FALSE.

The following conditions are TRUE when the total price is greater than the total price of at least one of the items in order number 1000. The first condition uses the ANY keyword; the second uses the MIN aggregate function:

total_price > ANY (SELECT total_price FROM sales
WHERE order_number = 1000)

total_price > (SELECT MIN(total_price) FROM sales
WHERE order_number = 1000);
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 68 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?