Advertisement
Guest User

Untitled

a guest
Jun 19th, 2018
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. /* BOT 2 */
  2. SELECT SYS_CONTEXT('USERENV','SID') "SYS_CONTEXT('USERENV','SID')" FROM "SYS"."DUAL" "A1";
  3.  
  4. /* Serializable */
  5. ALTER SESSION SET ISOLATION_LEVEL = Serializable;
  6.  
  7. /* Update data set */
  8. UPDATE JOURNEY SET COST = 101 WHERE JOURNEYID = 0;
  9.  
  10. /* COMMIT */
  11.  
  12.  
  13.  
  14.  
  15.  
  16. /* Read commited */
  17. ALTER SESSION SET ISOLATION_LEVEL = Read Committed;
  18.  
  19. /* Update data set */
  20. UPDATE JOURNEY SET COST = 101 WHERE JOURNEYID = 0;
  21.  
  22. /* COMMIT */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement