Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.39 KB | None | 0 0
  1. DECLARE
  2.   commentId NUMBER;
  3. BEGIN
  4. FOR comments IN (SELECT HTL_GST_CMT_ID FROM GST_ARR.HTL_GST_CMT)
  5.   LOOP
  6.     commentId := comments.HTL_GST_CMT_ID;
  7.    
  8.     UPDATE GST_ARR.HTL_GST_CMT
  9.     SET CREAT_TS = CREAT_TS + ROUND(DBMS_RANDOM.VALUE(0,100)) - 100
  10.     WHERE HTL_GST_CMT_ID = commentId AND TO_CHAR(CREAT_TS, 'YYYY-MM-DD') IN ('2017-03-02', '2017-03-03');
  11.    
  12.   END LOOP;
  13.   COMMIT;
  14. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement