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 Sequence ?

3 Answers  

---

How to load a large xml file?

0 Answers  

---

Explain the use of online redo log files in oracle.

0 Answers  

---

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

Respected sir, Please send me technical questions related to oracle apps..

0 Answers  

---

How to convert csv to table in oracle?

0 Answers  

---

difference between bind variable and variable

1 Answers   Attra,

---

Will you be able to store pictures in the database?explain.

0 Answers  

---

Difference between inner join vs where ?

0 Answers  

---

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 Answers  

---