Update two column of one table from another table In Oracle

This forum is for Database developer ( PostgreSQL, MySQL, SQL Server, Oracle etc...) and database Administrator
sandip
Posts: 123
Joined: Tue Aug 26, 2014 5:11 pm
Contact:

Update two column of one table from another table In Oracle

Postby sandip » Wed Aug 27, 2014 9:54 pm

How to Update two column of one table from another table in Oracle SQL? I tried but not able to update correctly more than one column.


Guest

Re: Update two column of one table from another table In Ora

Postby Guest » Wed Aug 27, 2014 9:56 pm

Below query is working for me. Update two column of TableA from TableB.

update TableA A set (A.First_name, A.Last_Name)= (Select B.First_name, B.Last_Name
from TableB B where A.EMp_ID=B.Emp_ID)


Return to “PostgreSQL, MySQL, SQL Server, SQL,PL/SQL, TeraData Developer and DataBase Administration”

Who is online

Users browsing this forum: No registered users and 1 guest