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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
