杨勇.txt

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

1.
declare
  i number:=0;
  j number;
begin
  for i in 0..3 loop 
      j:=i;
      loop
          exit when j>=3;
          dbms_output.put(' ');j:=j+1;
      end loop;
      for j in 1..(2*i+1)
      loop
          dbms_output.put('*');
      end loop;
      dbms_output.new_line();
  end loop;
  for i in 4..6 loop 
      j:=i;
      loop
          exit when j<=3;
          dbms_output.put(' ');j:=j-1;
      end loop;
      for j in 1..(7-2*(i-3))
      loop
          dbms_output.put('*');
      end loop;
      dbms_output.new_line();
  end loop;
end;