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 the syntax to add a record to a table?

782

---

How can check sql version from command line?

720

---

What is record type in pl sql?

747

---

what is oracle database ? : Sql dba

736

---

Is natural join and inner join same?

652

---

---

how to select first 5 records from a table? : Sql dba

693

---

Can a procedure in a package be overloaded?

754

---

what is single byte over head in oracle..?

2090

---

What is cursor and its types?

716

---

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

843

---

Is there a 64 bit version of ssms?

678

---

Is sql a dbms?

732

---

What language is oracle sql developer?

714

---

What are the ddl commands?

718

---

How many tables can you join in sql?

707

---