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
Cursor Employee Table. [Table create, insert and display]
Srinivas
query
oracle procedure example
procedure to calulate LCM of three numbers
DECODE() example
change output of table strings and numbers using ascii value modification
Cursor Explicit
Prova Supero
SQL Test