I think you would have to remove the MD alias.
On Wed, Nov 20, 2013 at 1:13 PM, ddf <orat...@msn.com> wrote: > 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. > -- -- 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.
