Tutorial#40 NVL Function in oracle SQL with example

[@atkuriajaykumar3701]

You deserve more views sir

[@EqualConnectCoach]

thanks

[@muhammadyasar9764]

Thank you sir.

[@atkuriajaykumar3701]

Thankyou sir

[@renukashanmukhi6269]

Sir can u make once again nvl video

[@vikastiwari8935]

Hi sir, Why NVL is working on commission_pct column in employees table?

[@vikastiwari8935]

every time it shows error :- invalid number

[@EqualConnectCoach]

select NVL(to_char(commission),'xxxx') from employees; u can use like this because commition is number and vvl works on character/varchar column only

[@shankhasreesen6522]

@@EqualConnectCoach but you haven't shown it in your video then how would we know

[@EqualConnectCoach]

If has null value it will work what is ur specific question

[@leeladharthada4694]

What if there are more than one null in a column and we have to assign different values that null

[@EqualConnectCoach]

it will replace all the null value of that column

[@atkuriajaykumar3701]

We can use nvl2 function

[@shamyumanoharan7217]

Can u pls post answers for 1st and 2nd questions sir😊

[@EqualConnectCoach]

Select nvl(commition, "null value available" from emp where firstname like 'S%'; u can do like that for others

[@shamyumanoharan7217]

EqualConnect Coach thanks sir

[@ajedits8093]

select commission_pct , first_name ,NVL(commission_pct,'Null Found')
from employees
where employee_id in (100, 101, 102, 103) ; . I have written this query for the first question
, i am getting error like invalid number please sugest

[@EqualConnectCoach]

,NVL(commission_pct,'Null Found') check this, in respect of datatype

[@cahn3860]

If the column is a number value then you will need to give it a number expression such 0
select
commission_pct,
NVL(commission_pct, 0)
from
employees;
In order to avoid this, you will need to convert the commisson_pct column as a character for example:
select
commission_pct,
NVL(to_char(commission_pct, '9.9'), 'Null Value')
from
employees;
This will return all the NULL values as 'Null Value'.

[@atkuriajaykumar3701]

Sir plz explain nvl2 also

[@EqualConnectCoach]

sure

[@shamyumanoharan7217]

Pls tell for 3 nd 4 sir

[@EqualConnectCoach]

in 3rd ,U have to tell output of that query and in 4th questions : display the salary from emp table and increase/decrease salary by 5

[@vibeherewithx]

@@EqualConnectCoach
5) select employee who hired after 2003.
Select employee from employees
Where hire_date > to_date
(" 31-dec-2003"," dd-mm-yyyy ");
Is this right ?

[@Channel_24_7]

thats very irritating into af

[@vishalugale2719]

don't do chutiya kind of things while recording video like over reacting