what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,

---

How to Remove the 3rd highest salary person record from table?

9 Answers   HCL, IBM,

---

select statement does not retrieve any records. what exception is raised?

2 Answers  

---

What is the usage of analyze command in oracle?

0 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

1 Answers  

---

---

What is a read only transaction in oracle?

0 Answers  

---

What happens if variable names collide with table/column names?

0 Answers  

---

pls explain connect by prior with example and its real time use

3 Answers  

---

What is difference between SQL and SQL*PLUS?

1 Answers  

---

How to experiment a data lock in oracle?

0 Answers  

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers   TCS,

---

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

---