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.

What is the difference between clustered and non-clustered indexes?

0 Answers  

---

What is assignment operator in pl sql?

0 Answers  

---

How can you load multi line records? : aql loader

0 Answers  

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

What is a natural join sql?

0 Answers  

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

What do you understand by pl/sql packages?

0 Answers  

---

what is the difference between granting and creating a view?

2 Answers  

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

Can a table contain multiple foreign key’s?

0 Answers  

---