Answer / anil kumar jampana

cursor for loop is also a cursor. Here no need to handle
open,fetch,close operations. These operations are handled
by for loop.

Answer / dipti

Another nice feature of the CURSOR FOR is the ability to
define the cursor inline. Below is a cursor that is not
declared in the declaration section of the executing
block. The cursor definition is included in the CURSOR FOR.
SQL> begin
2 for r_c11 in
(select author_last_name l_name,
3 author_first_name f_name
4 from author) loop
5 dbms_output.put_line(initcap(
6 r_c11.l_name||
', '||r_c11.f_name));
7 end loop;
8 end;
9

Answer / nishi

cursor for loop is also a cursor. Here no need to handle open, fetch, close operations. These operations are handled by for loop.

Answer / suresh somayajula

Cursor for loop implicitly declares %rowtype as Loop index
opens the cursor and fetch the rows from active set into
fields and then process it and then close the cursor.

Why partition by is used in sql?

0 Answers  

---

What is right join in sql?

0 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

How to select all records from the table?

0 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---

Explain the difference between triggers and constraints?

0 Answers  

---

Why are indexes and views important to an organization?

0 Answers  

---

How do you get column names only for a table (sql server)?

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

What are all the different normalization?

0 Answers  

---

Can we join tables without foreign key?

0 Answers  

---

What is the difference between sum and count in sql?

0 Answers  

---