WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

What is a trigger oracle?

0 Answers  

---

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

---

Difference between oracle's plus (+) notation and ansi join notation?

0 Answers  

---

What is forall Statement ?

2 Answers   Thermotech,

---

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers   MasterCard,

---

How do we get field detail of a table?

0 Answers  

---

How translate command is different from replace?

0 Answers  

---

How to divide query output into groups in oracle?

0 Answers  

---

how to find count rows in table without count function?

3 Answers   Oracle,

---

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.

0 Answers   IBM,

---

How to use "while" statements in oracle?

0 Answers  

---