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!

for update with order by

Ward Flores-OracleMar 9 2009 — edited Mar 9 2009

Hello all,

Does anyone know if "order by" has precedence over "for update"? In other words, using the following query. Will the resulting rows be sorted first and then locked or they will be locked first and then sorted?

SELECT /*+ cardinality(al 1) use_nl(al t) */ NULL
BULK COLLECT INTO l_nullvalue_list
FROM TABLE (i_list) al, my_table t
WHERE al.id = t.id
ORDER BY t.id
FOR UPDATE OF t.id;

Any help is very much appreciated.

Regards,
wf

This post has been answered by Timur Akhmadeev on Mar 9 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2009

Added on Mar 9 2009

16 comments

5,507 views