If you have an open cursor on a table, modify the same table and commit, what would happen?
Latest Answer: The open cursor execute the query associated with the cursor, identifies the result set, and position . ...
How does a stand alone procedures differ from that of other procedures?
Latest Answer: Stand Alone Procedure is not part of an Package. ...
Which one gives better performance,
co-related subquery or inline views? Why?
What is the main difference between the functions of DB_BUFFER_CACHE and LIBRARY_CACHE?
Latest Answer: DB Buffer cache: when a query is executed then server process looks for block in buffer cache. If the block is not available in buffer cache then server process reads the block from data files.Library cache:It contains the informations of most recently ...
Lets follow the following structure of granting priviledge..A -> B -> C -> D -> EIf we revoke priviledge from C, then what happens with D and E.
Latest Answer: hi, It depends upon the type of privilege you are revoking. Is it object priviledge or system priviledge. There is one major difference in the revocation of object privileges and system privileges. With objects, if you revoke a privilege from a user who ...
While creating a new user we set his password as identified globally, what does it mean?
Latest Answer: We dont set user's password as "identified globally". We write "identified globally" to decide user's scope.Details:In Oracle, we can create user in three ways:1. local user2. external user3. Global userDifferent commands to create these users:We create ...
A table which consist of atleast one primary or Unique key is called as Parent Table.
True / False (Justify)
Latest Answer: Wrong and RightDepends how you take it. If i have emp table without primary key and i search dept table through emp id. Then this would be wrong. So, depends how you take it all i say is it's not verdict but it's an concept ...
MERGE INTO SAS F USING (SELECT PRODID, PRODID+10 F, DESCRIP FROM PRODUCT) L ON (F.PRODID=L.PRODID) WHEN MATCHED THEN UPDATE SET F.PRODID=L.F WHEN NOT MATCHED THEN INSERT
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: These both are correlated subqueries.In the first one, we are knowing the salaries of employees who are earning less than there manager.In the second one we are knowing about the salaries of managers who are earning less than their employees whom they ...
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 ...
View page [1] 2 3 4 5 6 7 8 Next >>
Go Top
