case
declare
i number := 1;
j varchar2(11) ;
begin
case(i)
when 1 then j:='haha';
when 2 then j:='xixi';
else j:='no find';
end case;
dbms_output.put_line(j);
end;
cursor
declare
cursor cname is select * from sec_hrc_audit;
var11 cname%rowtype;
begin
open cname;
loop
fetch cname into var11;
dbms_output.put_line(var11.hrc_code);
exit when cname%notfound;
end loop;
dbms_output.put_line(rpad('superman',20,' SSS'));
close cname;
loop1
declare
cursor cursor_name is select * from sec_hrc_audit;
begin
for idx in cursor_name loop
dbms_output.put_line(idx.hrc_code);
end loop;
loop2
declare
begin
for idx in (select * from sec_hrc_audit) loop
dbms_output.put_line(idx.hrc_code||'一共行数');
end loop;
end;
cursor_count
declare
cursor cursor_name is select * from sec_hrc_audit;
rowc number(22);
begin
for idx in cursor_name loop
dbms_output.put_line(idx.hrc_code||'哈哈');
rowc := cursor_name%rowcount;
end loop;
dbms_output.put_line(rowc);
end;
cursor_forupdate
declare
cursor cursor_name is select * from sec_hrc_audit for update of hrc_code;
bighrc number(10);
begin
for idx in cursor_name loop
bighrc :=3;
update sec_hrc_audit set hrc_code = bighrc where current of cursor_name;
end loop;
commit;
cursor_变量
declare
type rc is ref cursor return sec_hrc_audit%rowtype;
var1 rc;
rt sec_hrc_audit%rowtype;
type rec is record (hrc_code number(4),hrc_name varchar2(2));
type rc2 is ref cursor return rec;
begin
open var1 for select * from sec_hrc_audit;
fetch var1 into rt;
dbms_output.put_line(rt.hrc_code);
end;
forLoop
declare
line number:=50;
separator varchar2(1):= '=';
actual varchar2(150);
i number :=1;
begin
for idx in 1..line loop
actual := actual||separator;
i:=i+1;
end loop;
dbms_output.put_line(actual);
end;
selectinto
declare
type rec is record(code number(2),num number(2));
rec1 rec;
begin
select * into rec1 from abc where hrc_code = 2;
null;
end;
whileloop
declare
line number:=50;
separator varchar2(1):= '=';
actual varchar2(150);
i number :=1;
begin
while (i<line) loop
actual := actual||separator;
i:=i+1;
end loop;
dbms_output.put_line(actual);
end;
隐式cursor
declare
begin
--delete abc where hrc_code = 1;
insert into abc(hrc_code) select hrc_code from sec_hrc_audit where hrc_code = 1;
if(sql%found)then
dbms_output.put_line('插入成功');
end if;
commit;
end;
（本文已被浏览 次） | | |
相关评论
