Answer Posted / samir kumar sahoo

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

How can we force the database to use the user specified rollback segment?

1151

---

List out the difference between commit, rollback, and savepoint?

1038

---

What is the exact use of Collections?

2143

---

Why do we use coalesce function in oracle?

1127

---

How to open a cursor variable?

1040

---

What is the sid in oracle?

972

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2068

---

What do you mean by redo log file mirroring?

1036

---

What is oracle open database communication (odbc)?

1030

---

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

1028

---

What are advantages of dateset in datastage?

2263

---

What is the usage of control file in oracle?

1090

---

How to invoke the data pump export utility?

1192

---

What happens if recursive calls get out of control?

1084

---

What is Library Cache in Oracle?

1144

---