1 Reply Latest reply: Feb 13, 2013 8:10 PM by rp0428 RSS

    Help with Update Statement

      I have a update statement that is not doing the actual update as returning more than one row.

      update NOTIFICATION1
      set CLASS =
      (select x||y
      from test a,DETAIL b
      where a."a_Fk"(+) = ('Az'||b.address_detail_pid);

      Any advice is appreciated.
        • 1. Re: Help with Update Statement
          Well the obvious is that you need to modify the query to return only one value.

          Post some sample data that shows the values before the update, what you expect the sub-query to return and the values after the update.

          We can't even try to reproduce your example with the DDL and some sample data.