Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- commentId NUMBER;
- BEGIN
- FOR comments IN (SELECT HTL_GST_CMT_ID FROM GST_ARR.HTL_GST_CMT)
- LOOP
- commentId := comments.HTL_GST_CMT_ID;
- UPDATE GST_ARR.HTL_GST_CMT
- SET CREAT_TS = CREAT_TS + ROUND(DBMS_RANDOM.VALUE(0,100)) - 100
- WHERE HTL_GST_CMT_ID = commentId AND TO_CHAR(CREAT_TS, 'YYYY-MM-DD') IN ('2017-03-02', '2017-03-03');
- END LOOP;
- COMMIT;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement