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

How do I learn what codesets are available in oracle?

1008

What is a static data dictionary in oracle?

1039

Give syntax for SQL and ORACLE joins.

1051

Can multiple columns be used in group by in oracle?

937

What is redo log?

1012

what is the difference between functional dependecy and multilevel dependency?

2423

How to set up autotrace for a user account?

987

How to delete a column in an existing table?

1024

What is oracle host variable?

992

Explain alias?

1087

What are the different types of failures that occur in Oracle database?

1021

What is oracle sid?

899

How to connect the oracle server as sysdba?

1023

What is oracle join syntax?

953

How oracle handles dead locks?

1029