刘洋.txt

关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品

1.
declare
i int:=1;
j int:=1;
rrow int:=1;
rrrow int:=1;
begin
 for rrow in 1..4 loop
   for j in 1..(4-rrow)loop
   dbms_output.put(' ');
   end loop;
   for i in 1..2*rrow-1 loop 
   dbms_output.put('*');
   end loop;
 dbms_output.new_line();
 end loop;
 for rrow in reverse 5..7 loop
 rrrow:=rrow-4;
   for j in 1..(4-rrrow) loop
   dbms_output.put(' ');
   end loop;
   for i in 1..2*rrrow-1 loop 
   dbms_output.put('*');
   end loop;
 dbms_output.new_line();
 end loop;
end;
2
declare 
nage emp.age%type;
begin
insert into emp(empno,ename) values (4444,'aaaa');
savepoint p1;
update emp set age=20 where emp.empno=7788;
select age into nage from emp where empno=7788;
if nage>40 then
rollback to p1;
else
commit;
end if;
end;