Use (ROW_NUMBER() OVER( ORDER BY xxx) instead of ROWNUM in query as a value

The reason for not using rownum as a value is because when you use in an insert, the value can be different than in a select using an order by clause.

but if you use analytic functions the problem is solved
(ROW_NUMBER() OVER( ORDER BY xxx)