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 do you get nicely formatted results from an oracle procedure that returns a reference cursor?

546

---

How to convert dates to characters in oracle?

577

---

How to create a new table by selecting rows from another table?

549

---

What are the attributes of cursor?

587

---

Difference between open_form and call_form in oracle.

676

---

---

What are internal user account in oracle?

567

---

How to define a cusotmer as a supplier in ORACLE R12

1726

---

What is recovery manager(rman) backup in Oracle?

624

---

How to do paging with oracle?

572

---

What is meant by a deadlock situation?

573

---

What privilege is needed for a user to insert rows to tables in another schema?

560

---

How to create a new table in oracle?

589

---

What is oracle database client?

551

---

How many anonymous blocks can be defined?

582

---

How to run the anonymous block again?

595

---