Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
cursor
select * from emp\\ declare cursor c1 is select sal from emp order by SAL desc ; v_sal emp.SAL%type; begin open c1; loop fetch c1 into v_sal; exit when c1%notfound; if c1%rowcount=13 then dbms_output.put_line(v_sal); end if; end loop; close c1; end;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
3
PL/SQL declaracionVariables
Bcom
Kartik DBMS Program
DEMO.CUSTOMER
Oracle Practice
SQLWithOuterAndInnerLoop_UnableToExecute
Prova Supero
test database table
Srinivas
stackse - search stackoverflow differently
Please log in to post a comment.