Advertisement
ExaGridDba

avoid log(0) error with nullif

Oct 23rd, 2015
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.93 KB | None | 0 0
  1. [oracle@stormking cdb12102 SQL]$ cat log0.SQL
  2. SELECT p, log ( 10,  NULLIF ( p, 0 ) ) lp
  3. FROM
  4. (
  5.         SELECT POWER ( 10, level - 3 ) p
  6.         FROM dual
  7.         CONNECT BY level <= 5
  8.         UNION
  9.         SELECT 0
  10.         FROM dual
  11. )
  12. ORDER BY p
  13. ;
  14.  
  15. quit
  16. [oracle@stormking cdb12102 SQL]$ sqlplus u/u@//stormking:1521/pdbm @ log0.SQL
  17.  
  18. SQL*Plus: Release 12.1.0.2.0 Production ON Fri Oct 23 23:02:56 2015
  19.  
  20. Copyright (c) 1982, 2014, Oracle.  ALL rights reserved.
  21.  
  22. LAST Successful login TIME: Fri Oct 23 2015 23:02:27 -04:00
  23.  
  24. Connected TO:
  25. Oracle DATABASE 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  26. WITH the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
  27. AND REAL Application Testing options
  28.  
  29.  
  30.          P         LP
  31. ---------- ----------
  32.          0
  33.        .01         -2
  34.         .1         -1
  35.          1          0
  36.         10          1
  37.        100          2
  38.  
  39. 6 ROWS selected.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement