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.

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

What is sp_helptext?

0 Answers  

---

What are sql built in functions?

0 Answers  

---

How do I create a memory optimized filegroup?

0 Answers  

---

What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

---

what are the different types of joins?

4 Answers   Choice Solutions,

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

When the mutating error will comes? and how it will be resolved?

2 Answers  

---

what is sql server agent? : Sql dba

0 Answers  

---

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

---

What is aggregate function in sql?

0 Answers  

---