var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ORA-01427 - single-row subquery returns more than one row
I've 2 tables
TABLE RE with these col
RE_ID varchar2(32) primary key
TABLE RE_NEW with these col
A_RE_ID + B_RE_ID = RE_ID
The col PROPERTY of RE_NEW is full and PROPERTY of RE is empty.
I'd like to populate PROPERTY of RE with same values of RE_NEW.
my query is
SET PROPERTY = (SELECT PROPERTY
where I run this query I get this error:
ORA-01427 - single-row subquery returns more than one row
What I wrong??
Re: ORA-01427 - single-row subquery returns more than one row
It means that for some value of RE_ID there are 2 or more rows in RE_NEW that match the WHERE clause, so Oracle doesn't know which one you want to get the PROPERTY value from.