Answer Posted / apsar

select sal from (select sal,count(sal) over order by salary desc c)temp where temp.c=&n;

Does oracle partitioning improve performance?

1001

---

What to do if the startbd.bat failed to start the xe instance?

1085

---

Explain the characteristics of oracle dba?

1120

---

What are the tools for Oracle ?

1067

---

How to put more than 1000 values into an oracle in clause?

1032

---

What are the oracle built-in data types?

1077

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2028

---

Explain coalesce function?

1207

---

Explain the use of inctype option in exp command.

1034

---

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

1028

---

what is insert all statement in sql

6526

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2140

---

What is an anonymous block?

1255

---

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

1062

---

What are data pump export and import modes?

1071

---