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

Why is oracle used?

897

How to create additional tablespaces for an new database?

987

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

987

What is a package ? What are the advantages of package ?

1047

What is a table in oracle?

942

How to create a new table in your schema?

1050

How to convert characters to numbers in oracle?

1020

How to experiment a data lock in oracle?

1012

How to rebuild an index in oracle?

990

How much memory your 10g xe server is using?

1065

How to delete an existing row from a table in oracle?

1028

How do we represent comments in oracle?

1009

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2099

What is the use of oracle?

1000

What is system global area (sga) in oracle?

946