What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

How to recover a dropped table in oracle?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

How to run the anonymous block again?

0 Answers  

---

What is the use of 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,

---

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  

---

which statement is running fastly ie insert or delete?

13 Answers   Oracle,

---

what is the difference between first normal form & second normal form?

11 Answers   IBM, Oracle,

---

What is Index Cluster ?

2 Answers  

---

What is recovery manager in Oracle?

0 Answers   MCN Solutions,

---

how the indexes are stored in the Oracle Database?

0 Answers  

---