What is the sql query to concatenate column values from multiple rows in oracle?

0 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers   iFlex,

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

How to list all indexes in your schema?

0 Answers  

---

Can objects of the same schema reside in different tablespace?

0 Answers  

---

Explain the use of grant option in exp command.

0 Answers  

---

12. Display the client name in upper case only and in lower case only.

1 Answers   Wipro,

---

What are the major difference between truncate and delete?

0 Answers  

---

How do I uninstall oracle client from windows?

0 Answers  

---

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 Answers  

---

What is an external table?

0 Answers  

---