oracle中存储过程的循环怎么写1,1,2,3,5,8,13,21,34,55,89,144,233,377……
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 16:23:14
![oracle中存储过程的循环怎么写1,1,2,3,5,8,13,21,34,55,89,144,233,377……](/uploads/image/z/1991850-42-0.jpg?t=oracle%E4%B8%AD%E5%AD%98%E5%82%A8%E8%BF%87%E7%A8%8B%E7%9A%84%E5%BE%AA%E7%8E%AF%E6%80%8E%E4%B9%88%E5%86%991%2C1%2C2%2C3%2C5%2C8%2C13%2C21%2C34%2C55%2C89%2C144%2C233%2C377%E2%80%A6%E2%80%A6)
oracle中存储过程的循环怎么写1,1,2,3,5,8,13,21,34,55,89,144,233,377……
oracle中存储过程的循环怎么写1,1,2,3,5,8,13,21,34,55,89,144,233,377……
oracle中存储过程的循环怎么写1,1,2,3,5,8,13,21,34,55,89,144,233,377……
存储过程如下:CREATEORREPLACEPROCEDURETEST(parm_ninteger)ASiinteger:=0;sinteger:=0;s1integer:=1;s2integer:=0;BEGINdbms_output.put(1);whilei<=parm_nloops:=s1+s2;dbms_output.put(',');dbms_output.put(s);s2:=s1;s1:=s;i:=i+1;endloop;dbms_output.put_line('');END;/测试:SQL>exectest(12)1,1,2,3,5,8,13,21,34,55,89,144,233,377PL/SQL过程已成功完成.