ORA-01427 - single-row subquery returns more than one row
hi,
I've 2 tables
TABLE RE with these col
RE_ID varchar2(32) primary key
PROPERTY char(1)
TABLE RE_NEW with these col
A_RE_ID varchar2(2)
B_RE_ID varchar2(6)
PROPERTY char(1)
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
UPDATE RE
SET PROPERTY = (SELECT PROPERTY
FROM RE_NEW
WHERE A_RE_ID=SUBSTR(RE.RE_ID,1,2)
AND B_RE_ID=SUBSTR(RE.RE_ID,3,6))
where I run this query I get this error:
ORA-01427 - single-row subquery returns more than one row
What I wrong??
Thanks
Raf
Re: ORA-01427 - single-row subquery returns more than one row
You can see in Oracle Error message what is wrong, that is very clearly. Try to execute query with your WHERE clause and get count(*) > 1.
Quote:
Originally posted by raf
ORA-01427 - single-row subquery returns more than one row