'Update table through row_number()

I've a table ANAGRAFICA in my db with 4 names: fabio, mrco, marco, mchele but mrco and mchele are incorrect (the column is NOME). I use this query to select a name through the row number:

SELECT NOME FROM 
   (SELECT NOME, ROW_NUMBER() OVER (ORDER BY (NULL)) R FROM ANAGRAFICA)
   WHERE R = 2;

and for example it gives me 'mrco'. Great,but how can i modify my query to update in order to correct that name on that particular row number?

oracle

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Update table through row_number()

Sources

Related Questions