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

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

Please Help Members By Posting Answers For Below Questions

How to update a table row with a record?

1016

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

1153

What are the ways tablespaces can be managed and how do they differ?

2373

What is oracle join syntax?

1006

What happens to the current transaction if a ddl statement is executed?

1017

What is the difference between count (*), count (expression), count (distinct expression)?

1013

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2970

How to delete all rows a table in oracle?

1071

What is tns service name?

1127

How to convert raw data type into text in oracle? Explain

996

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3053

How to turn on or off recycle bin for the instance?

1085

What is integrity and what is constraint??Explain with example

2286

Is oracle a language?

953

How data locks are respected in oracle?

1073