Advertisement
ExaGridDba

Still no NVL2 in PL/SQL 12.2

Oct 18th, 2017
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. [oracle@stormking cdb12201 ~]$ sqlplus /nolog @ conn.pdba.u.sql
  2.  
  3. SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 18 19:09:35 2017
  4.  
  5. Copyright (c) 1982, 2016, Oracle. All rights reserved.
  6.  
  7. Connected.
  8. SQL> declare n number; begin n := nvl(0,0); end;
  9. 2 /
  10.  
  11. PL/SQL procedure successfully completed.
  12.  
  13. SQL> declare n number; begin n := nvl2(0,0,0); end;
  14. 2 /
  15. declare n number; begin n := nvl2(0,0,0); end;
  16. *
  17. ERROR at line 1:
  18. ORA-06550: line 1, column 30:
  19. PLS-00201: identifier 'NVL2' must be declared
  20. ORA-06550: line 1, column 25:
  21. PL/SQL: Statement ignored
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement