Answer Posted / 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

how to drop an existing table in mysql? : Sql dba

805

---

What is indexing oracle sql?

785

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

965

---

What is the file extension for sql database?

713

---

What is union?

852

---

What is sql lookup?

710

---

What is mutating trigger?

806

---

What is integrity in sql?

798

---

What is a database? Explain

872

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

710

---

Does postgresql run on the cloud?

844

---

What do you mean by stored procedures?

782

---

What is a field in a database?

802

---

What is multiple partition?

734

---

what is a composite primary key ? : Sql dba

833

---