Answer Posted / abhisudipta

select d.dept_name,e.emp_nm,max(e.sal) as salary
from dept d, emp e
where d.dept_no=e.dept_no and e.emp_nm = (select emp_nm from
emp where sal=(select max(sal) from emp where
dept_no=d.dept_no))
group by d.dept_name,e.emp_nm;

What are the different oracle database objects?

1075

---

Why do we need oracle client?

923

---

How much memory your 10g xe server is using?

1086

---

Explain oracle insert into command?

1084

---

How to create a new tablespace in oracle?

966

---

How to convert a date to char in oracle? Give one example.

1041

---

How to write an inner join with the where clause in oracle?

1029

---

What is using clause and give example?

1014

---

What is a user role in oracle?

1100

---

When do I need to use a semicolon vs a slash in oracle sql?

1072

---

What is meant by joins?

1041

---

What are internal user account in oracle?

992

---

Differentiate between pre-select and pre-query?

1083

---

What is bulk copy or bcp in oracle?

1100

---

Use of an integrity constraint is better to validate data. Explain

1022

---