游标复习笔记
--while循环访问游标declare cursor cur_dept is select * from dept; v_dept cur_dept%rowtype;begin open cur_dept; fetch cur_dept into v_dept; while cur_dept%found loop dbms_output.put_line(v_dept
·
--while循环访问游标
declare
cursor cur_dept is
select * from dept;
v_dept cur_dept%rowtype;
begin
open cur_dept;
fetch cur_dept into v_dept;
while cur_dept%found
loop
dbms_output.put_line(v_dept.dname);
fetch cur_dept into v_dept;
end loop;
close cur_dept;
end;
--returning返回某一值
declare
v_sal emp.sal%type;
begin
select sal into v_sal from emp where ename='SMITH';
dbms_output.put_line(v_sal);
update emp set sal=sal+100 where ename='SMITH' returning sal into v_sal;
if v_sal >850 then
dbms_output.put_line(v_sal);
rollback;
end if;
end;
汇聚全球AI编程工具，助力开发者即刻编程。
更多推荐
1
0- 0
已为社区贡献1条内容
所有评论(0)