Answer Posted / sanjay pradhan

select ename,sal,deptno from emp where (deptno,sal) in
(select deptno,max(sal) from emp group by deptno);

Explain the use of file option in exp command.

1134

---

How do we create privileges in oracle?

1050

---

What are the types of partitions in oracle?

1038

---

What is merge statement used for?

1030

---

How will you differentiate between varchar & varchar2?

1048

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2002

---

What is data type in oracle?

1129

---

What is hash cluster in oracle?

1175

---

How index is implemented in oracle database?

1009

---

How to start your 10g xe server?

1046

---

What happens if you set the sga too low in oracle?

1156

---

How does Oracle guarantee data integrity of data changes?

2398

---

How to add a new column to an existing table with a default value?

1018

---

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

951

---

What are the data types in oracle?

1044

---