Oracle NVL, NVL2 and COALESCE functions Posted on August 13, 2015 by Carlos I have seen quite a few questions on internet forums and knowledge exchange sites about Oracle NVL, NVL2 and COALESCE functions for handling nulls, so I decided to write an article about them today. Tutorial IT Point SQL NVL and NVL2 Functions NVL and NVL2 Functions NVL() and NVL2():- These functions are used to treat the null value. NVL():- This function is used when we want to put any value in place of null value in column. Oracle 11g Database with ASM grid installation in NVL use in the ON portion of a JOIN - Oracle 11g. Discussion in 'SQL PL/SQL' started by OldSchoolCoder, I get the ORA-00904 on the NVL clause in the ON portion: ON ex1.DEPT = NVL(t1.DEPT, Club Oracle Forums. Forums > Oracle Database > SQL PL/SQL > Log in or Sign up; Forums. SQL tutorials for beginners This playlist consist all the videos on oracle database.This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. PL/SQL Tutorial Oracle for beginners PL/SQL Tutorial is an useful resource of pl/sql language for beginners and advanced developers. Skip to content. Home; PL/SQL NVL. The NVL function replace a null expression with other expression. The Oracle NULL Value (NVL) SQL operator is a great way to substitute NULL values with numeric values in Oracle SQL statements. The most common use for the NULL value (NVL) clause is to prevent mathematical operations from aborting with a zero divisor. Using Conditional Expressions - Guide for the preparation of Oracle Database 11g Administrator Certified Associate, OPN Certified Specialist exams. As an enhancement over NVL, Oracle introduced a function to substitute value not only for NULL columns values but also for NOT NULL columns Oracle Learning Library This Learning Library was designed to allow you to search for free online training content (OBEs, Demos and Tutorials)