|
Re: how to execute cursors [message #428 is a reply to message #424] |
Mon, 11 February 2002 19:09 |
Satish Shrikhande
Messages: 167 Registered: October 2001
|
Senior Member |
|
|
Cursor -
What are the Types - Implicit/Explicit
Where to define - Define it in declare section
How to Use -
cursor c1 is
select * from emp ;
When to use - When there is nay ppossibility of getting more than one record which we can't use in INTO .
Declare
cursor c1 is
select * from emp ;
begin
for z in c1 loop
dbms_output.put_line(z.empno);
end loop;
end;
set serverout on
|
|
|