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

Which is better Oracle or MS SQL? Why?

6482

What is a parameter file in oracle?

1187

Why packages are used in oracle?

1118

what is a Nested Loop join?

2173

What is null value in oracle?

1157

Can multiple cursors being opened at the same time?

1115

How to delete multiple rows from a table in oracle?

1113

What is the oracle implicit cursor?

1111

Whether any commands are used for months calculation? If so, what are they?

1137

What is pragma autonomous transaction in oracle?

1122

How do I start tns listener?

1095

Is rowid unique in oracle?

1043

What are the numeric comparison operations?

1167

How many types of segments in Oracle?

1114

Explain the different normalization forms?

1156