HomeНаука и техникаRelated VideosMore From: Siva Academy

Oracle interview question difference between null functions

34 ratings | 1419 views
Difference between NVL,NVL2, NULLIF and COALESCE NVL function will check whether the first input parameter is null, if first input parameter is null then the function returns the second parameter value as output. NVL2 function will check the first parameter, and return second parameter if the first parameter is not null, otherwise returns third parameter. NULLIF will compare the input parameters ( first and second parameter ), and returns NULL of both are same, otherwise returns the first parameter value. COALESCE, returns the first not null expression in the given input parameters. -------------------------------------------------------------------------------------------------------- List of all the SQL and PLSQL interview questions https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Html code for embedding videos on your blog
Text Comments (5)
Saptarshi Konar (30 days ago)
very good explanation
Siva Academy (29 days ago)
@Saptarishi, Thanks for your comment :-), --Siva
Sagar Jadhav (6 months ago)
good please make video on performance tuning
Siva Academy (6 months ago)
Thanks Sagar, Ya I am in process of creating PT with right examples, WIll be posting soon.
Martin Suresh (8 months ago)
very helpful information hatsoff sir

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.