ORA-01427: single-row subquery returns more than one row (in update)
Hi All,
I'm using a code like this to update some values:
update tableA a set a.Col1 =
(select b.Col2 from tableB b where a.id=b.id)
where a.Col1 is null
But it gives me this error:
single-row subquery returns more than one row
How to solve it Plz?
Note:
I'm using Oracle DB 10g R2