select*from emp where null=null; this command will not return any reco

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

Question Posted / samir kumar sahoo

8 Answers
18955 Views
IMS Health, NIIT, I also Faced
E-Mail Answers

select*from emp where null=null;

this command will not return any record bcoz the
condition null=null false as two null values are not equal.

select*from emp where 1=1;

will return all the records present in the table emp as
the condition 1=1 is always true.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the roles of dba?

1018

What are the uses of a database trigger?

926

How to empty your oracle recycle bin?

980

what is insert all statement in sql

6392

What privilege is needed for a user to connect to oracle server?

939

In what script is snap$ created? In what script is the scott/tiger schema created?

2654

Can we convert a date to char in oracle and if so, what would be the syntax?

956

What is user managed backup in Oracle?

1076

Why does for update in oracle 8 cause an ora-01002 error?

932

Explain a private synonyms?

980

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2244

Explain what are the advantages of views?

1012

Explain overloading. Can functions be overloaded?

934

What is set operator oracle?

921

Â What are the oracle DML commands possible through an update strategy?

1004