Hi, If you comapare null=null then it return 0 rows selected. Check the r

What is the result, when NULL is compared with NULL?

Question Posted / nhajare

Answer Posted / nhajare

Hi,
If you comapare null=null then it return 0 rows selected.
Check the result of this query...

select * from table_name where null=null;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is crud diagram?

877

How do you bind variables in pl sql?

1034

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1176

Are subqueries faster than joins?

949

how to install mysql? : Sql dba

1045

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1114

what is the difference between undefined value and null value? : Sql dba

1038

i have some prob lem to tell me about my self in interview first round ...

2114

What is a loop in sql?

936

What is sql used for?

1064

What is the use of nvl function?

1124

what are string data types? : Sql dba

972

What are the advantages of pl sql?

1070

Why do you partition data?

965

How to run sql statements through the web interface?

984