Problem solve
Get help with specific problems with your technologies, process and projects.
Update two columns with one UPDATE command
How to update two columns in a table with one update command?
How to update two columns in a table with one update command?
We've been getting a number of questions like this recently. On the surface they seem simple. After digging into them for a while, they still seem simple.
Do all of you have a copy of your SQL Reference manual? Every major database system, whether proprietary or open source, has a manual which you can browse for free on the Web.
update daTable
set Column1 = 9
, Column2 = 37
where Foo = 'Bar'
That wasn't so hard, was it.
This was last published in April 2007
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments