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

Can we use bind variables in oracle stored procedure?

949

What is max rowid in oracle?

1025

What is the implicit cursor in oracle?

1105

Can we write dml statement in function in oracle?

1081

How do I recompile a procedure in oracle?

964

What is a table index in oracle?

1131

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

What is a schema in oracle?

1012

what is Single Byte Overhead...?

2555

How are extents allocated to a segment?

1125

What is merge statement used for?

1024

How to create a table in a specific tablespace?

975

Difference between pre-select and pre-query

1106

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2286

What is a private synonym?

1588