Home » SQL & PL/SQL » SQL & PL/SQL » partition by rownum - clarify (oracle 9i)
partition by rownum - clarify [message #399553] Wed, 22 April 2009 22:44 Go to next message
Messages: 16
Registered: May 2006
Junior Member
Can someone please explain me what it does "max(rownum) over (partition by rownum - level" in the solution suggested in teh following link?
select ... from (select ..., rownum as rn, max(rownum) over (partition by rownum - level) as leaf_rn from ...) where rn = leaf_rn in the link : http://forums.oracle.com/forums/thread.jspa?messageID=1956369&

Re: partition by rownum - clarify [message #399564 is a reply to message #399553] Thu, 23 April 2009 00:45 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
What testcase did you create to view its behavior?
Previous Topic: CHAR and VARCHAR2
Next Topic: NULLIF
Goto Forum:

Current Time: Fri Oct 21 16:12:15 CDT 2016

Total time taken to generate the page: 0.08796 seconds