Plsql update inner join

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 10 years, 5 months ago. Active 2 years, 4 months ago. Viewed 40k times. I used to write T-SQL. I have two tables. In T-SQL, that is simple update t1 set t1. Update Thanks Cybernate and ypercube gave me two useful solutions. My actual table contains 80, records and only 3, needs update. MERGE statement takes 0.

Improve this question. Alex Yeung. Alex Yeung Alex Yeung 2, 7 7 gold badges 31 31 silver badges 47 47 bronze badges. Add a comment. Active Oldest Votes.

Improve this answer. Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website.

We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. Find centralized, trusted content and collaborate around the technologies you use most.

Connect and share knowledge within a single location that is structured and easy to search. In Oracle you can update a join if the tables are "key-preserved" , ie:. In your case since the updated value doesn't depend upon another table you could use a simple update with an EXIST condition, something like this:. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to update with inner join in Oracle Ask Question. Asked 9 years, 10 months ago. Active 2 years, 1 month ago. Viewed 41k times. Update table t set t.