What is the difference between primary key and unique key and foreign key in oracle?

0 Answers  

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

What is the sql query to concatenate column values from multiple rows in oracle?

0 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

3 Answers   HCL,

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

What is a partition in oracle?

0 Answers  

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

What is a deadlock ? Explain .

1 Answers  

---

What is the CAP theorem?

1 Answers  

---

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

0 Answers   MCN Solutions,

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

How to Select second Maximum salary in a Table ?

13 Answers   Oracle,

---