6 Replies Latest reply on Aug 1, 2012 12:33 PM by 6363

    Update query

      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