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 a behavioral trigger?

970

---

How do I write a cron which will run a sql query and mail the results to agroup?

972

---

Which command is used to delete a trigger?

1323

---

What is sql not null constraint?

1023

---

What does where 1/2 mean in sql?

1062

---

Which is better stored procedure or query?

955

---

What is the difference between rename and alias?

1338

---

What are different clauses used in sql?

1112

---

When is a declare statement required?

1136

---

How do I trace sql profiler?

967

---

Why is stored procedure faster than query?

954

---

What is example of database?

1051

---

What is raw datatype in sql?

1042

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1162

---

what are all the different normalizations? : Sql dba

1032

---