Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
ABC
My_employee
if-else condition in pl/sql
function to check if reverse of a string s1 is a superstring of string s2.
add pl/sql
SQL Test
Srinivas
SQLWithOuterAndInnerLoop_UnableToExecute
First_Last_Day
ishu