Answer / basanti

2 types
1. public synonym
2. private synonym

How to see the table columns used in an index?

0 Answers  

---

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  

---

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,

---

what is the exact definition for pointer?

7 Answers   Wipro,

---

How to select some rows from a table in oracle?

0 Answers  

---

---

How to delete all rows a table in oracle?

0 Answers  

---

What are the various oracle database objects?

0 Answers  

---

Explain parameter file in oracle.

0 Answers  

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

How view is different from a table?

0 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

what r routers?

1 Answers  

---