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.

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

What is the trigger in sql?

1 Answers  

---

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---

How do I create a sql script?

1 Answers  

---

What is trigger price?

1 Answers  

---

What is coalesce in sql?

1 Answers  

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1 Answers  

---

What is replication id?

1 Answers  

---

How do I quit sql?

1 Answers  

---

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

how to convert dates to character strings? : Sql dba

1 Answers  

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1 Answers  

---