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
19530 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

How to install oracle database 10g xe?

1064

Explain alias?

1193

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1227

Explain oracle’s server parameter file.

1041

What is a trigger and what are its types?

1330

Can we call procedure inside function in oracle?

1150

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2362

What are the original export and import utilities?

1260

What are the components of logical database structure in oracle database?

1139

How to turn on or off recycle bin for the session?

1174

What is a proxy class?

1107

What is an oracle database?

1111

What is coalesce function?

1147

How to create a new oracle data file?

1076

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1923