tmmdv

random

Mar 4th, 2016
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. WITH g AS
  2.   (SELECT NULL FROM sys.obj$ WHERE rownum<=5000)
  3. SELECT COUNT(*)
  4. FROM
  5.   (SELECT ora_hash(rownum, 50) x
  6.    FROM
  7.      g g1, g g2
  8.    WHERE
  9.      rownum <= 5e6
  10.   )
  11. WHERE x>=0;
  12.  
  13.  
  14.             COUNT(*)
  15. --------------------
  16.              5000000
  17. Elapsed: 00:00:01.77
Add Comment
Please, Sign In to add comment