Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
3_max_value_where_job_is_manager
select * from emp\\ declare cursor c1 is select sal from emp where JOB='MANAGER' 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=2 then dbms_output.put_line(v_sal); end if; end loop; close c1; end;
run
|
edit
|
history
|
help
0
even and odd plsql block
prime number programe using pl/sql
test database table
alle angemeldeten Benutzer können eine gegebene aktion ausgeben ( im Web )
6
a
Srinivas
addition of arrays
wq1
Simple calculator