Updating multiple rows in oracle

Rated 3.81/5 based on 904 customer reviews

Finally, the WHERE clause is outside the subquery to only update the product_id of 1, as it applies to UPDATE rather than to the subquery.

Using the data from the previous example (the product table), the company wants to deactivate all the products that have not had an order placed for them.

updating multiple rows in oracle-5

updating multiple rows in oracle-46

updating multiple rows in oracle-71

Our statement would look like this: You can see that the SET clause includes a subquery, which finds the MAX value of the price column in the product table and multiplies it by 1.2 to add 20%.

For example, 60,000 customers need their arrival_time to match their departure_time.

I understand that I can do this with one row and it work with a nested select statement in an update statement.

You will be given questions that you need to solve.

After each exercise, we provide the solution so you can check your answer.

Leave a Reply

  1. personals and dating and website 24-Oct-2019 23:48

    For other upcoming events, visit https:// for meet ups in Kalamunda, Mundaring and Roleystone.

  2. pennsylvania singles online dating 14-Apr-2020 07:04

    Our members include CEO’s, doctors, lawyers, entrepreneurs athletes and models, actresses and attractive single women.