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
Assignment 1(1)
To find out first day of month without trunc function
testElham
factorial
Srinivas
Example of Local and Global variables
testing
Connect by - delimiter
final
0607-3