first command will give no records whereas 2nd command will provide all r

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

Question Posted / shree

Answer Posted / shree

first command will give no records whereas 2nd command will
provide all records as 1 is equal to one.it is similar to
select * from emp;.

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is recovery manager(rman) backup in Oracle?

1194

How to use "in out" parameter properly?

1057

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

1080

How do I limit the number of oracle database connections generated by weblogic server?

1078

What is ordinary table in oracle?

1166

Is truncate autocommit in oracle?

1095

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

1076

Explain the dml?

992

How to initialize variables with default values?

1253

Is insert autocommit in oracle?

1083

What is the meaning of recursive hints in oracle?

1050

What language does oracle use?

1119

What is the difference between truncate & delete command?

1193

In the oracle version 9.3.0.5.0, what does each number shows?

1311

What is a named program unit?

1097