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