1.statament "no rows select" 2.statament "the 14 rows disp

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

Question Posted / bhavish

Answer Posted / bhavish

1.statament "no rows select"
2.statament "the 14 rows displayed
why because the true condition and null values are different

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to generate query output in html format?

1212

Where are the settings stored for each instance in oracle?

1154

What is MTTR advisor in Oracle?

1141

What is the difference between PFILE and SPFILE in Oracle?

1112

Explain oracle’s server parameter file.

1041

What are nested tables?

1227

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

1091

What are the differences between number and binary_float in oracle?

1149

What are the four Oracle system processes that must always be up and running for the database to be useable?

1054

What are the components of logical database structure in oracle database?

1139

What is a database schema in oracle?

1153

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2170

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1098

What is a view and how is it different from a table?

1137

Explain what are clusters?

1158