Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
cursor
declare cursor c1 is select * from program2 where course='mca'; v_id number(2); v_name varchar2(20); v_course varchar2(20); begin open c1; loop fetch c1 into v_id,v_name,v_course; exit when c1%notfound; dbms_output.put_line(v_id||' '||v_name||' '||v_course); end loop; close c1; end;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
DEPT
Understanding basic loop
Factorial from SQL
t1
if-else condition in pl/sql
Srinivas
Assignment 1(1)
Srinivas
Srinivas
Srinivas
Please log in to post a comment.