6 Replies Latest reply: Aug 1, 2012 7:33 AM by 6363 RSS

    Update query

    944524
      hi guys,

      i need to update distinct fields into single column using update query is it possible

      for eg

      select remarks from tab;

      output: done
      not done
      yet to be done

      i need to update another table using cursor like
      update tab1 set field = done||notdone||yet to be done
      where remarks = i.remarks

      or any other way to go