Guest User

Untitled

a guest
Jun 23rd, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. SQL> CREATE TABLE trigger_test (id INT NOT NULL)
  2. 2 /
  3.  
  4. Table created
  5.  
  6. Executed in 0,031 seconds
  7. SQL> INSERT
  8. 2 INTO trigger_test
  9. 3 SELECT level
  10. 4 FROM dual
  11. 5 CONNECT BY
  12. 6 level <= 1000000
  13. 7 /
  14.  
  15. 1000000 rows inserted
  16.  
  17. Executed in 1,469 seconds
  18. SQL> COMMIT
  19. 2 /
  20.  
  21. Commit complete
  22.  
  23. Executed in 0 seconds
  24. SQL> TRUNCATE TABLE trigger_test
  25. 2 /
  26.  
  27. Table truncated
  28.  
  29. Executed in 3 seconds
  30. SQL> CREATE TRIGGER trg_test_ai
  31. 2 AFTER INSERT
  32. 3 ON trigger_test
  33. 4 FOR EACH ROW
  34. 5 BEGIN
  35. 6 NULL;
  36. 7 END;
  37. 8 /
  38.  
  39. Trigger created
  40.  
  41. Executed in 0,094 seconds
  42. SQL> INSERT
  43. 2 INTO trigger_test
  44. 3 SELECT level
  45. 4 FROM dual
  46. 5 CONNECT BY
  47. 6 level <= 1000000
  48. 7 /
  49.  
  50. 1000000 rows inserted
  51.  
  52. Executed in 17,578 seconds
Add Comment
Please, Sign In to add comment