What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,

---

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

1 Answers   Polaris,

---

What are the types of Database Links ?

2 Answers  

---

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 Answers  

---

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

---

---

What is a materialised view?

5 Answers  

---

How do you rate yourself in oracle and sql server ?

2 Answers   Keane India Ltd,

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

Define Transaction ?

5 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   IBM, Wipro,

---

What is oracle rowcount?

0 Answers  

---

How can we delete duplicate rows in a table?

0 Answers  

---