0 Replies Latest reply: Oct 6, 2009 5:14 AM by 695117 RSS

    update one table with data from another table

    695117
      Hi

      I am trying to update one table with data from another table .

      but I am getting the following error please suggest how to solve this problem:

      SQL> edit
      Wrote file afiedt.buf

      1 UPDATE pkglist_d
      2 SET (pkglist_d.waybill_no) =
      3 (SELECT waybill_d.waybill_no
      4 FROM waybill_d
      5 WHERE waybill_d.pkglist_no =
      6* pkglist_d.pkglist_no)
      SQL> /
      (SELECT waybill_d.waybill_no
      *
      ERROR at line 3:
      ORA-01427: single-row subquery returns more than one row

      warm regards
      Sandy