利用SQL 制作report 時, 有時為了參考, 便在query 中加入 row no. 在Oracle 中, 可以透過hierarchy query 進行.
SELECT LEVEL AS ID FROM DUAL CONNECT BY LEVEL <= 12;
[Oracle] 利用Level 進行Row generation Query
About C.H. Ling
262 Articles
a .net / Java developer from Hong Kong and currently located in United Kingdom. Thanks for Google because it solve many technical problems so I build this blog as return.
Besides coding and trying advance technology, hiking and traveling is other favorite to me, so I will write down something what I see and what I feel during it.
Happy reading!!!
Be the first to comment
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply