-
Date Conversions
How to convert any kind of date that comes in any format from the user to 'yyyymmdd' in Oracle?
-
Multi Row Sub-Queries
Query 1. SELECT sal FROM emp e WHERE sal < any (SELECT sal FROM empWHERE empno=e.mgr) (o/p:11 row) Query 2. SELECT SAL FROM emp e WHERE sal < any (SELECT sal FROM empWHERE mgr=e.empno) (o/p:1 row) What is the difference between the above 2 queries.
-
Pair and Non Pair Wise Comparison
What is the difference between pair wise & non pair wise comparison in a multiple column subquery. In which case are these used?
-
-