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  

---

What do you mean by merge in oracle and how can we merge two tables?

0 Answers  

---

What is the difference between Sleep and Wait? (Java)

1 Answers   RBS,

---

What are the built-in functions used for sending Parameters to forms ?

0 Answers   Oracle, TCS,

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

0 Answers   Infosys,

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

0 Answers   NIC,

---

What is self-referential integrity constraint ?

2 Answers   SunGard,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

What is a shared pool?

1 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

What are the types of Database Links ?

2 Answers  

---

How to retrieve data from an cursor to a record?

0 Answers  

---