This content has been marked as final. Show 4 replies
This hopefully should do... Not tested.
Check this will clarify...
UPDATE GLOGOWNER.DRIVER_ASSIGNMENT SET PREV_DRIVER_ASSIGNMENT_SEQ_NUM = 100, UPDATE_USER = user, -- this holds the current user name UPDATE_DATE = sysdate -- holds the current SYSDATE WHERE DRIVER_ASSIGNMENT_SEQ_NO=1;
select user,sysdate from dual;