Answer Posted / u.radha

SELECT * FROM (SELECT ENAME,SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RN FROM EMP) WHERE RN = 2;

How to convert raw data type into text in oracle? Explain

998

---

What is an oracle recycle bin?

1015

---

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

1064

---

Oracle

2380

---

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

1046

---

What is a table index?

1108

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1694

---

Explain oracle 12c new features for developers?

1063

---

What is logical backup in oracle?

1025

---

How to get execution statistics reports on query statements?

1105

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1122

---

What is the difference between sharding and replication?

1060

---

How to empty your oracle recycle bin?

1029

---

What is the max number of columns in an oracle table?

1003

---

What are the system predefined user roles?

1048

---