real time applications of nullif?

Answer Posted / babu

nullif basically allows you to compare 2 expressions of
same datatype and return null if both are equal. else it
would return the first expression.eg:
nullif(10,10) returns null

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of optimization?

516


What is difference between sql function and stored procedure?

503


What is use of term?

614


Do foreign keys improve performance?

541


How do I tune a sql query?

510






what is offset-fetch filter in tsql? : Transact sql

530


Does google use sql?

506


How do you break a loop in pl sql?

519


How to make a copy values from one column to another in sql?

569


Is sql low level language?

572


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

577


What are the types of operators available in sql?

546


What is dml with example?

511


Where not exists in sql?

501


What are the different set operators available in sql?

561