Just like following update query: Update emp set salary * 1.7 from emp where deptno = 10
I am performing folowing update and errored out on Error at Command Line:11 Column:4 Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause: *Action: error comming from red highlighted area update query is as follow: update SU_S2H_MEMBER_DETAIL set MD.SU_WAIVER_IND = 'Y', MD.SU_WAIVER_SOURCE = null, MD.SU_WAIVER_REASON = NULL, MD.SU_WAIVER_NOTE = 'Tracking change', MD.SU_WAIVER_YMDWAIVE = TO_CHAR(sysdate,'YYYYMMDD'), MD.OP_NBR = 'MANL', MD.YMDTRANS = TO_CHAR(sysdate,'YYYYMMDD'), MD.SU_PROCESS_ID = 'PROG REQ', MD.SU_PROCESS_TIME = TO_CHAR(sysdate,'HHMISS') from AMIOWN.SU_S2H_MEMBER_DETAIL MD where MD.SU_INCENTIVE_TYPE = 'WELL'; COMMIT; -- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.