Tutorial#41 NVL2 function in oracle SQL database by rakesh malviya

Explaining NVL2 SQL null function / Oracle NVL2 Function / NVL2 Function in SQL Query / what NVL2 Function in Oracle SQL, its perfect video for fresher/beginner/starter it has an assignment, practical and theory part of NVL2 Function, its best video of NVL2 function

Assignment link:

you may get the answer to the following question in this series
difference between nvl and nvl2
nvl in SQL
coalesce function in Oracle
oracle nvl
nvl in where clause
how to handle null values in where clause in Oracle
oracle nvl
nvl in where clause

In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.

Link for assignment:

follow me on:
Facebook Page:

Contacts Email:

Instagram:

Twitter:

#NVL2FunctionInSQL #OracleSQLTraining #SQLTutorial

[atiftemuri]

out is output of following query
select NVL(To_char(MNG), employee_id, 'Head of Company') from employee

I am confuse in that SIR

[sathishj]

sir how can i apply nvl function in number datatype

[ramyakumar]

Sir, while executing this query, I get an error as invalid numbers of arguments
select last_name, commission_pct,
NVL2(TO_CHAR(commission_pct, salary), 'Null value') from employees;

[mohammedafthab]

assignment question 1:
select first_name, NVL2(to_char(commission_pct), commission_pct, 'NULL IS FOUND')
from employees where first_name like 'D%';

Sir, whenever expression1 is number data type and expression 2 is character data type then how to write a query?

[mr.schnitzel]

Somehow in the playlist, this comes after #69.