PL/SQL基础

1.游标，循环
DECLARE
CURSOR c IS
select * from bill_account where id in (4003,4004,4005);
BEGIN
FOR temp in c LOOP
dbms_output.put_line(temp.name);
END LOOP;
END;


2.IF语句
DECLARE
val_a number;
BEGIN
val_a:=1;
IF val_a=0 then
dbms_output.put_line('aaa'||val_a);
ELSIF val_a=1 then
dbms_output.put_line('bbb'||val_a);
END IF;
END;

3.定义常量
DECLARE
val_a CONSTANT NUMBER :=1;
BEGIN
dbms_output.put_line(val_a);
END;

4.更新并提交
update bill_account set state=1 where id=4003;
COMMIT;

5.CASE结构
DECLARE
val_a CONSTANT NUMBER :=1;
BEGIN
CASE
WHEN val_a=0 then
dbms_output.put_line('aaa'||val_a);
WHEN val_a=1 then
dbms_output.put_line('bbb'||val_a);
END CASE;
END;

6.WHILE...LOOP结构
DECLARE
val_a NUMBER;
BEGIN
val_a:=5;
while val_a>0 loop
dbms_output.put_line(val_a);
val_a:=val_a-1;
end loop;
END;

7.LOOP...EXIT结构
DECLARE
val_a NUMBER;
BEGIN
val_a:=5;
LOOP
val_a:=val_a-1;
dbms_output.put_line(val_a);
EXIT when val_a<1;
END LOOP;
END;