Comments embedded. On Tuesday, November 19, 2013 1:39:25 PM UTC-7, Vijay Patel wrote:
> Just like following update query: > Update emp > set salary * 1.7 > from emp where deptno = 10 > > Which is incorrect; you've already stated you're updating EMP in the UPDATE line, the FROM line has no place in such an update. The correct statement would be: Update emp set salary * 1.7 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; > > To follow the correct example: 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') where MD.SU_INCENTIVE_TYPE = 'WELL'; This performs the update you want to execute. David Fitzjarrell -- -- 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.
