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
19006 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 can we force the database to use the user specified rollback segment?

1079

How to pass parameters to procedures?

981

What is oracle database client?

982

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2136

Explain how you would restore a database using RMAN to Point in Time?

2104

What is the parameter mode that can be passed to a procedure?

988

Explain what are the different type of segments?

918

Why is oracle database so popular?

951

What is Reduced List of Values?

2112

Please explain compound trigger in oracle?

1003

What is the max number of columns in an oracle table?

938

What is the best way to do multi-row insert in oracle?

1022

How to upsert (update or insert into a table)?

961

What are the uses of linked server and explain it in detail?

1011

Can you create a synonym without having a table?

990