1 2 Previous Next 19 Replies Latest reply on Feb 19, 2013 11:40 AM by Paul Horth

    single row sub query returns more than one row

      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

        1 2 Previous Next