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: Tue Apr 25 13:32:54 CDT 2017

Total time taken to generate the page: 0.27756 seconds