declare
age varchar2(20);
begin
select ename into age from emp where empno=8888;
dbms_output.put_line('name is '||age);
end;
declare
v_deptno emp.deptno%type:=&no;
begin
update emp set sal=sal*1.1 where deptno=v_deptno;
dbms_output.put_line('修改了行数 '||sql%rowcount);
END;
declare
v_deptno emp.deptno%type:=&no;
begin
update emp set sal=sal*1.2 where deptno=v_deptno;
if sql%found then
dbms_output.put_line('操作成功');
else
dbms_output.put_line('操作失败');
end if;
end;
declare
v_salary emp.sal%type:=&tsal;
v_empno emp.empno%type:=&tno;
begin
update emp set sal=v_salary where empno=v_empno;
commit;
exception
when others then
rollback;
end;
declare
v_ename emp.ename%type;
v_job emp.job%type;
begin
select ename,job into v_ename,v_job from emp where empno=&no;
dbms_output.put_line('name is '||v_ename||' job is '||v_job);
end;
--if else elsif 的用法
declare
age number(6):=&tage;
begin
if age<60 then
dbms_output.put_line('在60分以下');
elsif age<70 then
dbms_output.put_line('合格了');
elsif age<70 then
dbms_output.put_line('好');
elsif age<85 then
dbms_output.put_line('良');
elsif age<100 then
dbms_output.put_line('优秀');
else
dbms_output.put_line('error');
end if;
end;
--loop
declare
i int:=1;
begin
loop
dbms_output.put_line('i =='||i);
exit when i=10;
i:=i+1;
end loop;
end;
declare
j int:=1;
begin
while j<=10 loop
dbms_output.put_line('j == '||j);
j:=j+1;
end loop;
end;
09-21
09-21
09-21