Updating multiple rows oracle

The WHERE clause specifies which record(s) that should be updated.I have about 60,000 rows that I'm needing to update the information from column_a to column_b.

Let us start simple, and pretend that the department with id # 20, “Marketing” is from now on going to be named “Customer Relations”.But, the syntax example above might not show the whole truth, since we can have a situation like this: In the expanded version of our UPDATE syntax above, the value that we want to update column1 with, actually comes from a different table.



  1. Pingback:

  2. eric   •  

    While the actress walked away after clicking selfies with fans, Kunal was still on the counter clearing the food bill.” Well, this is not the first incident, where she’s been spotted dominating him.

  3. eric   •  

    Her ultimate fate is never revealed, but the possibility of her returning to sex work is not ruled out.

  4. eric   •  

    A dating scammer will most likely opt to perform her scam on dating websites where she doesn’t need to meet anyone to register.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>