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
Latest Answer: how this query is possible i dont know, how the emp number and manager number will be same, i think the query in meaning less r am not understanding properly i dont know,,,, Let some one explain this...! ...
What is the difference between pair wise & non pair wise comparison in a multiple column subquery. In which case are these used?
Latest Answer: In pair wise comparison we write like this:"where (MGR_ID, DEPT_ID) IN (SUBQUERY)"IN non pair wise comparison we write like this:"where (MGR_ID) IN (SUBQUERY)and (DEPT_ID) IN (SUBQUERY)"In first one we are checking two columns simultaneously ...
What is the actual processing being done at backend or server side to retrive the data or complete the DML operation.
In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW .To avoid these execeptions. How do you write SQL statement in alternative way?
Latest Answer: can take count of the actual query and based upon the count you can proceed likeSELECT empname INTO v_empname FROM Employee WHERE job = 'MANAGER'; Instead of this you can first check the countSELECT COUNT(1) INTO v_cntmanager FROM ...
How to repair the tnsnames.ora file.
File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine.
How to create LOV dynamically at runtime & attach to text field?
What is execution hierarchy in execution in Oracle forms?
In order to 'Compute Sum' clause in the SQL reports which of the following is mandatory1) Break on 2) Order by 3) Set page size 4) Set feedback
How can we force the database to use the user specified rollback segment?
What will be the outputdbms_shared_pool.keep('sys.standard','p');
View page << Previous 1 [2] 3 4 5 6 7 8 9 Next >>
Go Top
