oraacle
martes, 16 de junio de 2015
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)
Entradas más recientes
Entradas antiguas
Página Principal
Suscribirse a:
Entradas (Atom)