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
techluver
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&

thanks
Re: partition by rownum - clarify [message #399564 is a reply to message #399553] Thu, 23 April 2009 00:45 Go to previous message
Frank
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: Sat Dec 03 22:01:45 CST 2016

Total time taken to generate the page: 0.16346 seconds