what is the output of select * from emp where null=null &
select * from emp where 1=1

Answer Posted / anitha

select * from emp where null=null: will not return any rows
in the table since two null values are not always same.

select * from emp where 1=1 : will return all the rows in
the table because 1 is always equal to 1.

Is This Answer Correct ?    36 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to calculate date and time differences in oracle?

790


Is it possible to split the print reviewer into more than one region ?

2050


How to loop through data rows in the implicit cursor?

835


how to do daily transactions with out sql* loader control file regesterd in apps?

1456


Can we use bind variables in oracle stored procedure?

715


Can the query output be sorted by multiple columns in oracle?

777


What does sharding mean?

786


Which is better Oracle or MS SQL? Why?

5915


What is Data Dictionary Cache in Oracle?

931


How do I know if oracle client is installed on windows?

722


What is the maximum number of triggers that can be applied to a single table?

798


What is a data dictionary and how can it be created?

845


Explain index?

1019


How to synchronize 2 schema's objects?

1935


What are the original export and import utilities?

790