¿ How I can update only one row ?
Hello,
I have to update a table called status where the status to change is for example 300 and I want to change to 50, the next query is not working, the message that I receive is:
ORA-01732: data manipulation operation not legal on this view,
And this is the query:
update (SELECT a.* FROM (SELECT codcocina,status,fecmodif FROM vd.vdpedido ORDER BY FECMODIF DESC) a WHERE rownum = 1) set STATUS = 300
So Im telling to sql that the first row that contain the codcocina, status(whatever the value is) order by date (fecmodif) set the status = 300 to the first value (definied by rownum = 1).
Any help?????, Sorry for my english.