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 write a query with a right outer join in oracle?

1151

Explain database link?

1097

What privilege is needed for a user to connect to oracle server?

979

How to convert times to characters in oracle?

1014

What are the differences between primary key and unique key?

998

How to define and use table alias names in oracle?

924

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1636

List out the types of joins.

1138

How to use null as conditions in oracle?

1058

How to shutdown your 10g xe server from command line?

1070

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2025

How to define a data source name (dsn) in odbc manager?

1011

What is private procedure oracle?

998

how to make an oracle object

2340

Give the advantages and disadvantages of clusters.

1041