Answer Posted / samir kumar sahoo

SELECT DISTINCT salary FROM (SELECT DISTINCT salary,ROWNUM
rn FROM employee ORDER BY salary desc) WHERE rn=1;

How to write text literals in oracle?

1059

---

How to export data with a field delimiter?

1022

---

What are the different windows events activated at runtime ?

2881

---

How to insert a record into a table?

1055

---

Why packages are used in oracle?

1045

---

What is analyze command used for?

1044

---

Can we protect our pl/sql source code?

1028

---

How to define a cusotmer as a supplier in ORACLE R12

2212

---

How oracle handles dead locks?

1055

---

What privilege is needed for a user to create indexes in oracle?

1011

---

What is the scope of a local variable?

1044

---

How to load data through external tables?

1120

---

How do we create privileges in oracle?

1029

---

How to use subqueries with the in operator using oracle?

1070

---

How to establish administrator authentication to the server?

1023

---