David Phillips - November 19th, 2006 [entries|archive|friends|userinfo]
David Phillips

[ website | david.acz.org ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

November 19th, 2006

Pivot Tables in Oracle [Nov. 19th, 2006|09:50 pm]
This trick is a fast and efficient method for generating a set with any number of rows:

SELECT level
FROM dual
CONNECT BY level <= 100 # row count
LinkLeave a comment

navigation
[ viewing | November 19th, 2006 ]
[ go | Previous Day|Next Day ]