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;

What is integrity and what is constraint??Explain with example

1695

---

Is postgres faster than oracle?

557

---

What are internal user account in oracle?

567

---

What is difference between cartesian join and cross join?

582

---

What is object data modeling?

501

---

---

How to create a stored function in oracle?

585

---

Can you create a synonym without having a table?

551

---

How do we create privileges in oracle?

582

---

how to clone 9i Database on to 10g Database.

1820

---

What is the recommended interval at which to run statspack snapshots, and why?

2430

---

What is rowid and rownum in oracle?

538

---

How to delete a column in an existing table in oracle?

600

---

How oracle handles dead locks?

598

---

How to define a data field as not null?

628

---

How can I combine multiple rows into a comma-delimited list in oracle?

575

---