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

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1013

---

explain the advantages and disadvantages of stored procedure? : Sql dba

1009

---

what is csv? : Sql dba

995

---

What is crud sql?

982

---

What is data profiling in sql?

1076

---

What is restrict in sql?

1115

---

what is query cache in mysql? : Sql dba

1036

---

what is sql server agent? : Sql dba

1102

---

What are database links used for?

1046

---

What is microsoft t sql?

944

---

What is rtm in testing?

1110

---

What is a sql select statement?

1038

---

Can we use insert statement in function?

999

---

What is procedure explain with example?

959

---

What do you understand by case manipulation functions?

1034

---