oracle update 和order by 问题

Question

UPDATE LOCATION A SET A.RECEIVINGLOTNUMBER=('02'||'003'||lpad(rownum,'3','0')) WHERE A.Zoneid='56AC662C131C4EE091DD1BBD173F72B2' AND A.Locationline='1' AND 1<A.LOCATIONCOLUMN AND A.LOCATIONCOLUMN<20 ORDER BY A.LOCATIONCOLUMN DESC,A.LOCATIONLAYER ASC;

Answer 1

要更新哪些数据，已经被where限定了，要更新成什么值，set里也确定了，此时order by没有意义！