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 Java Pool in Oracle?

1171

How to use an explicit cursor without open statements?

1055

How to rename a column in an existing table?

1035

What is backup in Oracle?

1004

What are the different types of record groups in oracle? Explain each of them

1025

How can windows applications connect to oracle servers?

1057

How to lock and unlock a user account in oracle?

1106

Explain temporal data types in oracle

1095

How to set a transaction to be read only in oracle?

1093

What is a tns service name?

1009

Differentiate between function and procedure in oracle.

1077

What privilege is needed for a user to query tables in another schema?

973

How to view existing locks on the database?

1053

How to create a stored program unit?

1228

How to apply filtering criteria at group level in oracle?

1042