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.
Dig deeper on Oracle and SQL
Related Q&A from Rudy Limeback, SQL Consultant, r937.com
Read an example of an SQL case expression from our SQL expert Rudy Limeback.continue reading
Read about the Mimer Validator, a tool used to verify your SQL code, in this tip from SQL expert Rudy Limeback.continue reading
Read SQL expert Rudy Limeback's advice for counting combinations in a table with SQL's GROUP BY clausecontinue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.