Oracle Sql update command

Question

update cds set numberinstock=numberinstock+3 order by cdname asc

i am using above update command in oracle but it is giving error SQL command not properly ended.

an order by in an update statement does not make sense. What are you trying to achieve? — user330315
– user330315, Commented May 4, 2014 at 11:14
i am trying to update the column in ascending order in cdname ,this command is working in mysql but not in Oracle — aman kumar
– aman kumar, Commented May 4, 2014 at 11:18
"update the column in ascending order in cdname" does not make any sense either. You don't "update in a certain order". You update. And just because MySQL accepts a statement doesn't mean the statement makes sense in the first place. — user330315
– user330315, Commented May 4, 2014 at 11:20

one angry researcher · Accepted Answer · 2014-05-04 11:18:06Z

3

You cannot combine an UPDATE statement with an ORDER BY clause. Update changes the records in a table, ORDER BY is usually used to order the records in a query set (e.g. after a SELECT statement) but not in the DB table itself.

What do you wish to achieve by using ORDER BY in this statement? Consider doing this instead:

UPDATE cds SET numberinstock = numberinstock + 3;

SELECT * FROM cds ORDER BY cdname asc

answered May 4, 2014 at 11:18

one angry researcher

6124 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle Sql update command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related