select * from emp where null=null: will not return any rows in the table

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

Question Posted / anitha

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

Answer Posted / anitha

select * from emp where null=null: will not return any rows
in the table since two null values are not always same.

select * from emp where 1=1 : will return all the rows in
the table because 1 is always equal to 1.

Is This Answer Correct ?

36 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what are the type of synonyms?

1062

What are ddl statements in oracle?

1023

What is a package in oracle?

1037

How to invoke the original export import utilities?

989

How to check the oracle tns settings?

996

What is object data modeling?

907

How to define a procedure inside another procedure?

972

Explain the function of optimizer in oracle?

1070

How to commit the current transaction in oracle?

1051

What are the differences between char and varchar2 in oracle?

1084

what is the use of system.effective.date variable in oracle?

1062

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

1022

How to concatenate two text values in oracle?

1057

What is ASM (Automatic Storage Management) in Oracle?

1140

How to load excel data sheet to oracle database

976