Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Help HELP
when executing a query, I recieve the error message below.
update t set(total_available)=
(select distinct
count(L)
from tuv t, xyz x
where s.r = c.r (+)
group by s.r);
ERROR at line 2:
ORA-01427: single-row subquery returns more than one row
Anyone know how i should write this to get a result of total_available??
Book Title Cost total_available 123 The Firm 23 5
with many thanks
Jonus
Received on Thu Apr 08 1999 - 00:00:00 CDT