This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Feb 19, 2013 3:40 AM by Paul Horth RSS

single row sub query returns more than one row

don123 Newbie
Currently Being Moderated
hi, please help me to resolve this, working with oracle 11g.


update twypoly t1 set t1.twyindex=(select twyindex from twyinfo t2 where t2.id=t1.id);

the error message is:
*
ERROR at line 1:
ORA-01427: single-row subquery returns more than one row

thanks
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points