• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 627
  • Last Modified:

update table set column and select from another table to udpate multiple columns

I have a update statement
update test
set (col1, col2) = (
                                  select (col1,col2) from tableA
                             )

did not work - Ora - 0907 - missing right parentheseis
0
mahjag
Asked:
mahjag
1 Solution
 
Raju SrivatsavayeSoftware EngineerCommented:
try this:
update test
set (col1, col2) = (select col1,col2
                              from tableA);
0
 
mahjagAuthor Commented:
The above query to update is not working and I am getting "single row subquery returns more than a row" error in production , I saw that it was kind of working in dev but I am now in prod and it does not - can in anyway you can help me -
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now