Answer Posted / neeraj

No, Both are different, If we use the combination "unique+not null" the referential integrity is not maintained and that is not the case with primary key.
I think you got the difference.

What is the max number of columns in an oracle table?

742

---

How to load a large xml file?

824

---

What are the different oracle database objects?

821

---

Difference between the “verify” and “feedback” command?

1078

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

764

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1632

---

How are extents allocated to a segment?

801

---

What is the data pump export utility?

856

---

Are truncate and delete commands same? If so why?

851

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1888

---

how the indexes are stored in the Oracle Database?

1975

---

How to rename an index in oracle?

833

---

What are the ansi data types supported in oracle?

720

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1996

---

What is program global area (pga) in oracle?

794

---