Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
DEPT
zama
1
add of two num
test out
Srinivas
g
Srinivas
Aufgaben laut Benutzer durchsuchen
nth highest salary in Oracle using DENSE_RANK