• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 630
  • 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
1 Solution
Raju SrivatsavayeSoftware EngineerCommented:
try this:
update test
set (col1, col2) = (select col1,col2
                              from tableA);
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 -
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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