PL/SQL 阶乘的方法

客户要求打印条码时打印数量为订单数量取整，例如：

 PO数量为10 则打印 10张条码；

PL/SQL 实现方法如下： 

SELECT L.*

                     FROM PO_LINES_ALL L,

                          (SELECT ROWNUM RN

                             FROM DUAL

                           CONNECT BY ROWNUM <=

                                      (SELECT L.QUANTITY

                                         FROM PO_LINES_ALL L

                                        WHERE L.PO_LINE_ID = 4830)) R

                    WHERE L.PO_LINE_ID = 4830