Answer Posted / kk

SELECT d.DEPARTMENT_NAME,max(e.salary) from HR.EMPLOYEES e
join HR.DEPARTMENTS d
on e.DEPARTMENT_ID=d.DEPARTMENT_ID
group by d.DEPARTMENT_NAME;

Who developed oracle & when?

1007

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370

---

Can multiple cursors being opened at the same time?

1066

---

How would you change old and new values in an insert, delete and update triggers?

1023

---

What are the types of trigger in oracle?

984

---

What is a user account in oracle?

1121

---

What is oracle data type?

973

---

How to use "startup" command to start default instance?

1041

---

Explain what are synonyms used for?

1042

---

How to convert dates to characters in oracle?

1042

---

What are the roles of dba?

1070

---

How to call a stored function in oracle?

1020

---

Why do we use bulk collect in oracle?

1063

---

What is an oracle and why it is used?

1154

---

Why do you use stored procedures and state some of its disadvantages?

1028

---