PL/SQL Cursor Example with Parameter

PL/SQL Cursor Example with Parameter:

declare
vno number;
cursor sname(vno number) is select * from student where id=vno;
begin
vno:=:vno;
for i in sname(vno)
loop
dbms_output.put_line(i.name);
end loop;
end;

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.