TRUNC(ROWNUM/2,-4)
每兩萬條區分一個群組
結論 : 用於報表轉出Excel的分頁挺有用處的
Tag
- Oralce - PL/SQL (27)
- EBS [API] (11)
- EBS [OM] (7)
- C# (6)
- EBS [PO] (6)
- EBS [Admin] (5)
- EBS [BOM] (4)
- EBS [INV] (4)
- EBS [WIP] (4)
- EBS [MRP] (3)
- EBS [WSH] (3)
- ASP.NET (2)
- JAVA Collection (2)
- Oracle (2)
- Oracle Optimization (2)
- EBS [GL] (1)
- EBS [RCV] (1)
發表文章
沒有留言:
張貼留言