Updating multiple columns in oracle

Below is the basic syntax for the UPDATE statement: This is not the complete syntax of the update statement.If you want to review the complete syntax of the UPDATE statement then please refer to Books Online.These two different tables will be used in my UDPATE statement examples below.

UPDATE some_table SET column_x = CASE WHEN x_specific_condition THEN new_value_for_x ELSE column_x END, column_y = CASE WHEN y_specific_condition THEN new_value_for_y ELSE column_y END, WHERE some_more_conditions Problem with above is, each column (x, y) still gets updated with their own value if some_more_conditions return true irrespective of their specific conditions returning true.

SQL courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL saves time and valuable corporate resources, allowing companies to do more with less.

I wish to update the columns of a particular record in a table with values from another table.

There would be 5 columns needing their values updated.

Search for updating multiple columns in oracle:

updating multiple columns in oracle-56

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating multiple columns in oracle”

  1. The success story of Pardis and Payman inspired me and I decided to sign up on IP back in 2005. He messaged me "Let me see what spring is like on Jupiter and Mars". The 5 Star Safety Program at Iranian Personals is our commitment to ensuring that you’ll have a safe and enjoyable experience on our site.