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

NVL2 Function in SQL Query

3 ratings | 1588 views
NVL2(): The Oracle NVL2 function extends the functionality found in the NVL function. It lets you substitutes a value when a null value is encountered as well as when a non-null value is encountered. Syntax: NVL2( string1, value_if_NOT_null, value_if_null ) Arguments: string1 is the string to test for a null value. value_if_NOT_null is the value returned if string1 is not null. value_if_null is the value returned if string1 is null. Queries used in video: select ename, NVL2(mgr,'Yes','No Manager') from emp; select ename,sal,NVL2(comm,'Has some value here','No Value') from emp;
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

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