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

What is PL/SQL ?

2220

What are the different types of modules in oracle forms?

1050

What is connection pooling in oracle?

1018

How to drop an index in oracle?

1120

Can we store images in oracle database?

1068

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114

what's query optimization and without use of IN AND Exist can we get another way data from query

2200

Explain alias?

1193

Why we use bulk collect in oracle?

1116

How to speed up webrick?

1125

How to grant create session privilege to a user in oracle?

1055

What privilege is needed for a user to delete rows from tables in another schema?

1137

What are the advantages of oracle 12c?

1236

How to pass parameters to procedures in oracle?

1083

What is bulk copy or bcp in oracle?

1184