Answer Posted / aswini

select dept_id from emp group by dept_id having count(*)=(Select max(count(*)) From Emp group by dept_id)

What is a procedure in oracle?

1199

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2971

---

How to turn on or off recycle bin for the session?

1110

---

How to end the current transaction in oracle?

1030

---

What happens if the imported table already exists?

1033

---

Is there any function in oracle similar like group_concat of mysql?

1053

---

Is there a function to split a string in plsql?

1062

---

What is oracle datasource?

987

---

What privilege is needed for a user to delete rows from tables in another schema?

1070

---

What is translate in oracle?

1100

---

Give syntax for SQL and ORACLE joins.

1094

---

How to get a list of all user accounts in the database?

1087

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1111

---

what is reindexing?

1678

---

What are the different types of record groups in oracle? Explain each of them

1026

---