Null=Null returns no row but 1=1 returns entire row of the table.

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

Question Posted / raj

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

Answer Posted / raj

Null=Null returns no row but 1=1 returns entire row of the
table.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the use of compress option in exp command.

964

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4291

Explain self joins in oracle?

949

What is difference between sid and service name in oracle?

903

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1045

How to use group functions in the select clause using oracle?

1022

Explain the different normalization forms?

1008

1) Does oracle have any table which contain all the exceptions and it's code internally?

1696

Why do we use coalesce function in oracle?

1050

How remove data files before opening a database?

997

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

1056

What is an oracle tablespace?

981

How to update values on multiple rows in oracle?

971

What is flashback in Oracle?

963

How to write an inner join with the where clause in oracle?

994