Answer / basanti

2 types
1. public synonym
2. private synonym

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

5 Answers   Microsoft, Oracle, TCS,

---

Give the various rollback segment states.

0 Answers  

---

List the types of joins used in writing subqueries?

0 Answers  

---

what are indexes..how many types of index's are there and what are they?

7 Answers   Green Info Solutions, TCS,

---

What happens if you lost a data file?

0 Answers  

---

What is a cluster?

2 Answers  

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

0 Answers  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

Whatz the main diff between Subquery and a Join

14 Answers   Oracle, Zeta Interactive,

---

What is the difference between a vector and an Array? (Java)

3 Answers   RBS,

---

What is a trigger and what are its types in oracle?

0 Answers  

---

where we have to use ON clause and where we have to use USING clause in JOINS

2 Answers  

---