Select 'oracle' from dual where null = null;A. oracleB. nullC. error outD. no rows selected

debjani

• Aug 25th, 2005

 

error out

Andyk

 Profile Answers by Andyk 

• Dec 15th, 2005

 

D No rows selected.

SQL> select 'oracle' from dual where null=null;

no rows selected

SQL>

ganesh

• Jan 20th, 2006

 

correct answer :oracle

vadivel

• Feb 6th, 2006

 

answer is : No rows selected

because oracle is a not a table just a printing statement.

sneh

• May 16th, 2006

 

No rows selected because two nulls can't be equal.

Dhruv DBA

• Jul 28th, 2006

 

No rows selected, its will not show an error because null is a reserved word and there is no need to put it in single quote.Like we always do incase of string or characters.

Sampada _Sawant

 Profile Answers by Sampada _Sawant 

• May 12th, 2008

 

D. no rows selected

d.rajjesh

 Profile Answers by d.rajjesh 

• Aug 26th, 2008

 

no row selected

rahulg5211

 Profile Answers by rahulg5211 

• Aug 17th, 2010

 

It'll not return any output. but query is right and -It'll run.

S Ramesh

• Jul 19th, 2016

 

D. no rows selected

HARSHVARDHAN

• Nov 20th, 2016

 

C. error out

Gopi

• Jul 19th, 2018

 

D.no rows selected because Null value not equal to null