DEAR ALL,

ANY or SOME : Compares a value to each value in a list or retuned by a query. Must be

preceded by =,!=,>,<,<=,=> Evalutes FALSE when query returns no rows.

select empno,ename,sal from emp where sal = any(1500,3000);

EMPNO ENAME    SAL

------- ---------- ----------

7499 ALLEN 1600

7566 JONES 2975

7839 KING 5000

7902 FORD 3000

so ,optimizer take above query as ,

--select empno,ename,sal from emp where sal>1500 or sal>3000;

ALL : Compares a value to every value in a list or return by a query .Must be preceded by

=,!=,>,<,=>,<=. Evalutes to TRUE if the query returns no rows.

select empno,ename,sal from emp where sal > ALL (1600,3000);

EMPNO ENAME SAL

---------- ---------- ----------

7839 KING 5000

-- in other words optimizer take this query as ,

--select empno,ename,sal from emp where sal 1600 AND sal>3000;

Regards,

Nikhil