Answer / madhuri

WHERE CURRENT OF clause is used to update the current row of
the active set of a cursor

Answer / swapna

WHERE CURRENT OF clause in an UPDATE,DELETE statement
refers to the latest row fetched from a cursor.

Answer / vipul varshney

It allows to apply updates and deletes to the row currently
being addressed, without the need to explicitly reference
the ROWID.
You must include the FOR UPDATE clause in the cursor query
so that the rows are locked on OPEN.

What are pl sql procedures?

0 Answers  

---

How do you sort in sql?

0 Answers  

---

What is the maximum database size for sql express?

0 Answers  

---

What is a procedure in pl sql?

0 Answers  

---

Is keyword pl sql?

0 Answers  

---

What is cursor in pl sql?

0 Answers  

---

What is scope and visibility in PL/SQL?

0 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

what are the differences between binary and varbinary? : Sql dba

0 Answers  

---

What are different types of indexes?

0 Answers  

---

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers  

---

What is the use of procedures?

0 Answers  

---