Answer Posted / pr@$@d

Null means unknown value
The value null can be regarded as an unknown value.
Therefore, the following select statement returns null:

select 5+7+null+9 from dual;

Note : A null can be assigned but it can not be equated
with anything: Even itself.

Regards,
-Pr@$@d.
prasadreddi@ymail.com

How to assign data of the deleted row to variables?

1056

---

How to define a variable of a specific record type?

1054

---

How to get last row id?

971

---

Why is oracle used?

923

---

What is the disadvantage of User defind function?

2270

---

what is the difference between functional dependecy and multilevel dependency?

2445

---

How do you tell what your machine name is and what is its IP address?

2075

---

What is a dead lock in oracle?

1098

---

what is normalisation?what are its uses?

2249

---

What are the ansi data types supported in oracle?

935

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1027

---

What is the difference between a user and a schema in oracle?

1018

---

How do I spool in oracle?

986

---

How translate command is different from replace?

1060

---

Why do you create or replace procedures rather that drop and recreate.

990

---