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……

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过程已成功完成.