<div>
The above query to update is not working and I am getting &quot;single row subquery returns more than a row&quot; 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 - 
</div>


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 -

<div>
<div class="content wysiwyg-content">
I have a update statement <br />
update test <br />
set (col1, col2) = (<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; select (col1,col2) from tableA<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)<br />
<br />
did not work - Ora - 0907 - missing right parentheseis
</div>
</div>


I have a update statement 
update test 
set (col1, col2) = (
                                  select (col1,col2) from tableA
                             )

did not work - Ora - 0907 - missing right parentheseis

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

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.