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

What is full join?

896

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1003

---

what is clause? : Sql dba

1003

---

Is oracel sql developer written in java?

1058

---

explain commit and rollback in mysql : sql dba

937

---

What is a natural join?

991

---

explain the difference between myisam static and myisam dynamic. : Sql dba

884

---

What is pivot query?

1013

---

What is the difference between a query and a report?

900

---

Is vs as in pl sql?

933

---

What is varchar sql?

1059

---

Can we rollback truncate?

944

---

how to delete an existing column in a table? : Sql dba

951

---

What is the use of prepared statement?

952

---

What is break?

1140

---