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

GeekInterview.com > Placement Papers > Oracle > Technical

Go To First | Previous Question | Next Question

Technical | Question 30 of 126

Select 'oracle' from dual where null = null;

A. oracle
B. null
C. error out
D. no rows selected

Total Answers and Comments: 8

Last Update: August 26, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: d.rajjesh

no row selected

Above answer was rated as good by the following members:
rickyheartthrob2004

August 25, 2005 04:54:54

debjani

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

error out

Is this answer useful? Yes | No

December 15, 2005 04:59:17

Andyk

Member Since: December 2005 Contribution: 2

RE: Select 'oracle' from dual where null = null;

D No rows selected.

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

no rows selected

SQL>

Is this answer useful? Yes | No

January 20, 2006 02:28:59

ganesh

RE: Select 'oracle' from dual where null = null;

correct answer :oracle

Is this answer useful? Yes | No

February 06, 2006 05:33:04

vadivel

RE: Select 'oracle' from dual where null = null;

answer is : No rows selected

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

Is this answer useful? Yes | No

May 16, 2006 03:08:07

sneh

RE: Select 'oracle' from dual where null = null;

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

Is this answer useful? Yes | No

July 28, 2006 09:00:01

Dhruv DBA

RE: Select 'oracle' from dual where null = null;

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.

Is this answer useful? Yes | No

May 12, 2008 11:06:43

Sampada _Sawant

Member Since: May 2008 Contribution: 2

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

D. no rows selected

Is this answer useful? Yes | No

August 26, 2008 02:39:41

d.rajjesh

Member Since: August 2008 Contribution: 2

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

no row selected

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank