|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
The problem with just dropping the wrapping is that the restriction (rownum) is applied before the order by, so which rows you get back is not controlled. Also, pretty sure you cannot do the FOR UPDATE in Oracle in the inner query. Not really sure how Oracle expects users to perform paging queries with locks...