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 use values from other tables in update statements using oracle?

1079

Explain what are the uses of rollback segment?

1013

Explain temporal data types in oracle

1095

What is the scope of a local variable?

1067

What is java oracle used for?

1019

What is index-organized table in Oracle?

1069

How to sort output in descending order in oracle?

1043

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

How do I spool in oracle?

1004

How to change system global area (sga) in oracle?

1013

How to call a stored function with parameters?

1041

What is a sub query and what are the different types of subqueries?

1125

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

What is dynamic proxy?

1005

Can you have more than one content canvas view attached with a window ?

2333