Ora2Pg Migration – Rownum in update queries
The rownum in Oracle is a Pseudo column, we can use it in select query. Similarly it can be used in update query as well with caution. Oracle works fine with rownum while it is used in update query like below. Note, rownum is not my favorite thing but can’t avoid seeing them while migrating…