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 do I know if I have sql express or standard?

1062

---

What is mdf ldf and ndf?

1055

---

What is varchar sql?

1201

---

What is the use of desc in sql?

1015

---

How many tables can a sql database have?

1023

---

Is primary key always clustered index?

1062

---

What is the purpose of using pl/sql?

1186

---

what is the difference between a having clause and a where clause? : Sql dba

1152

---

Which is faster joins or subqueries?

1031

---

What schema means?

936

---

What is the difference between left and left outer join?

987

---

Why is a trigger used?

987

---

What is the largest value that can be stored in a byte data field?

1054

---

Why trigger is used in sql?

1012

---

Why do we create stored procedures & functions in pl/sql and how are they different?

989

---