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

What is a trigger oracle?

1048

Is primary key indexed by default in oracle?

942

can u plz provide me oca sql dumps please i need them

1910

What is MTTR advisor in Oracle?

1047

Why does Oracle not permit the use of PCTUSED with indexes?

2378

11. Display the client number and name and the client number and name of the person who referred that client.

2285

How to use subqueries with the exists operator in oracle?

981

How do I call oracle stored procedures that take no parameters?

1040

What are the original export and import utilities?

1077

How to rebuild an index in oracle?

982

What are the differences between char and nchar in oracle?

1032

Why is oracle used?

891

What is a sub query? Describe its types?

972

What is varray?

1049

What is the difference between online and offline backups?

992