Answer Posted / khan

DELETE FROM
(SELECT EMP_ID, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS CNT FROM EMPLOYEE)
WHERE CNT = 3;

What are the major difference between truncate and delete?

1060

---

How to display row numbers with the records?

1081

---

Can you drop an index associated with a unique or primary key constraint?

1022

---

Point out the difference between user tables and data dictionary?

985

---

How do I call oracle stored procedures that take no parameters?

1120

---

What is the difference between PFILE and SPFILE in Oracle?

1062

---

How many types of table in Oracle?

1128

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2070

---

How to speed up webrick?

1076

---

List the parts of a database trigger.

1053

---

How to check your oracle database 10g xe installation?

988

---

How to create a table in a specific tablespace?

976

---

What is tns name?

981

---

What privilege is needed for a user to insert rows to tables in another schema?

1015

---

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

2139

---