What will be the output for the below Query
Select 'High' from dual where null = null;

Answer Posted / shijo

The Answer will always be null, since you never can equate a
NULL to another NULL. if the query was "Select 'High' from
dual where null IS null;" The answer would have been "High"

Is This Answer Correct ?    61 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of views in sql?

738


Which language is used in sql?

721


What do you mean by “trigger” in sql?

787


How to get unique records from a table?

679


How can a pl sql block be executed?

678






What is %type in sql?

687


What is cross join sql?

674


Why we use cross join?

699


What is exit statement?

738


what is a stored procedure? : Sql dba

776


What is pl sql in oracle?

777


Is a table valued function object?

753


Can a table have no primary key?

772


What is clustered index in sql?

775


What is scope and visibility in PL/SQL?

765