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

What is oracle database client?

990

---

What is analyze command used for?

1024

---

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

993

---

What are nested tables?

1118

---

What are the limitations oracle database 10g xe?

991

---

What is system global area (sga) in oracle?

946

---

What are the differences between primary key and unique key?

959

---

How to write numeric literals in oracle?

1141

---

Is primary key indexed by default in oracle?

947

---

How to store pictures on to the database?

934

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2146

---

How to lock and unlock a user account in oracle?

1044

---

Is java required for oracle client?

941

---

What is a system tablespace and when it is created?

933

---

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

937

---