Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ROW_NUMBER()

782594Oct 31 2011 — edited Oct 31 2011
Hi,

In the following query the partition by and order by is given as NULL

select row_number() over (partition by null order by null) rn, a.*
from wfmtmp a;

Does it mean, there will be no partitioning or ordering applied to the window function?

Thanks
Arun
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2011
Added on Oct 31 2011
4 comments
685 views