Answer Posted / apsar

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

What is bulk copy or bcp in oracle?

602

---

Can we write dml statement in function in oracle?

629

---

Explain the dml?

590

---

What operating systems are supported by oracle database 10g xe?

575

---

Explain implicit cursor.

553

---

---

How to delete a column in an existing table?

589

---

How to view the tablespaces in the current database?

552

---

How to see free space of each tablespace?

586

---

What is the difference between count (*), count (expression), count (distinct expression)?

553

---

how to handle exceptions in post production

942

---

How to rename a column in an existing table?

613

---

How to select an oracle system id (sid)?

578

---

How would you begin to troubleshoot an ORA-3113 error?

1589

---

can u plz provide me oca sql dumps please i need them

1461

---

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

585

---