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

Respected sir, Please send me technical questions related to oracle apps..

1771

What is an oracle database table?

968

When do I need to use a semicolon vs a slash in oracle sql?

1040

What to do if the startbd.bat failed to start the xe instance?

1026

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

1015

What do you mean by merge in oracle?

945

Explain implicit cursor.

969

How a database is related to tablespaces?

995

Explain the use of rows option in imp command.

1053

What happens if you use a wrong connect identifier?

995

What is sharded cluster?

937

How to get a list of all background sessions in the database?

952

Does oracle charge for java?

1020

How to start instance with a minimal initialization parameter file?

1000

What is a relational database management system?

1076