ExaGridDba

Did I create 1 row or 4294967297?

Aug 7th, 2015
290
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. SQL*Plus: RELEASE 11.1.0.7.0 - Production ON Fri Aug 7 22:09:14 2015
  3.  
  4. Copyright (c) 1982, 2008, Oracle.  ALL rights reserved.
  5.  
  6. Connected.
  7. SQL>
  8. SQL> @ cr.TABLE.feedback.SQL
  9. SQL> DROP TABLE feedback;
  10.  
  11. TABLE dropped.
  12.  
  13. Elapsed: 00:00:01.17
  14. SQL> CREATE TABLE feedback
  15.   2  (
  16.   3          n NUMBER
  17.   4  );
  18.  
  19. TABLE created.
  20.  
  21. Elapsed: 00:00:00.06
  22. SQL>
  23. SQL>
  24. SQL> INSERT /*+ append */ INTO feedback
  25.   2  SELECT n
  26.   3  FROM feedbackstage;
  27.  
  28. 1 ROW created.
  29.  
  30. Elapsed: 00:49:28.54
  31. SQL> COMMIT;
  32.  
  33. COMMIT complete.
  34.  
  35. Elapsed: 00:00:00.30
  36. SQL> SELECT COUNT(*) FROM feedback;
  37.  
  38.   COUNT(*)
  39. ----------
  40. 4294967297
  41.  
  42. Elapsed: 00:01:05.54
Advertisement
Add Comment
Please, Sign In to add comment