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

State any two functions of oracle?

983

---

How many memory layers are in the oracle shared pool?

1107

---

What are a cluster and non-cluster index?

958

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2075

---

How to write a query with an inner join in oracle?

976

---

How to delete a column in an existing table?

1020

---

how may join possible between (requisition with purchase order)

2170

---

How do I reset a sequence in oracle?

1052

---

How to turn on or off recycle bin for the session?

1037

---

How to create an oracle testing table?

1010

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1058

---

Explain alias?

1080

---

How many types of tables supported by oracle?

1020

---

Explain integrity constraint?

1109

---

Are truncate and delete commands same? If so why?

1081

---