Answer Posted / gaurav arora

The answer-6 is quite matching with my stuff. Let me clear
it in more writting:
1. When we compare two nulls then the result
always 'false'. The main reason is the null is not a value
its neither an empty nor a empty space, so the actual
result is null which places as null.
2. When we compare a null with another which has some value
like some int value then the result is false. The actual
result is false and not null.

Consider the following examples:

--null = null is null which is false
Declare @intNull1 int
Set @intNull1 =null
Declare @intNull2 int
Set @intNull2=null
If @intNull1=@intNull2
Print 'null = null is true'
Else
Print 'null = null is false'

--Now assign some value
Set @intNull1 = 1
If @intNull1=@intNull2
Print 'null = int value is true'
Else
Print 'null = int value is false'

Thanks,
Gaurav Arora
http://stuff4mdesktop.blogspot.com/

What is the difference between execution of triggers and stored procedures?

1155

---

what are set operators in sql? : Sql dba

1108

---

What type of database is cloud sql?

1158

---

How will you distinguish a global variable with a local variable in pl/sql?

1201

---

What is coalesce sql?

1056

---

Mention what are the benefits of pl/sql packages?

1155

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1244

---

what are all the different types of indexes? : Sql dba

1104

---

Can a composite key be null?

1034

---

What is the process of debugging?

1125

---

How do I order columns in sql?

1073

---

What is the syntax to add a record to a table?

1151

---

What pl/sql package consists of?

1135

---

What are the datatypes available in pl/sql ?

1151

---

define sql update statement ? : Sql dba

1159

---