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 This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are triggers and its uses?
What is difference between primary and secondary key?
How do I quit sql?
What are stored procedures in mysql?
what is datawarehouse? : Sql dba
How can you fetch first 5 characters of the string?
What is duration in sql profiler trace?
What is record variable?
How many sql commands are there?
What is procedure explain with program?
How to know the last executed procedure?
How many sql statements are used? Define them.
Does truncate need commit?
How do I remove all records from a table?
Does truncate remove indexes?
