《sql九九乘法表》由会员分享,可在线阅读,更多相关《sql九九乘法表(4页珍藏版)》请在金锄头文库上搜索。
1、PLSQL九九乘法表方法一Basic loopdeclare i number:=1; j number:=2; result number := 0; begin loop loop result := i * j; dbms_output.put(j | * | i | = | result |chr(9); j:=j+1; exit when j9; end loop; dbms_output.put_line(); i:=i+1; j:=2; exit when i9; end loop; end;方法二For loopdeclare result number := 0; begin
2、 for i in 1.9 loop for j in 2.9 loop result := i * j; dbms_output.put(j | * | i | = | result |chr(9); end loop; dbms_output.put_line(); end loop; end;方法三While loopdeclare i number:=1; j number:=2; result number := 0;begin while i10 loop while j10 loop result := i * j; dbms_output.put(j | * | i | = | result |chr(9); j:=j+1; end loop; dbms_output.put_line(); i:=i+1; j:=2; end loop;end;