Answer Posted / pravin jadhav

delete from table_name where rowid not in (select max(rowid) from table group by
duplicate_values_field_name);
or
delete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from
table_name tb where ta.dv=tb.dv);

How to use values from other tables in update statements using oracle?

568

---

various types of hints and their usage

2131

---

How to use "in out" parameter properly?

617

---

How to grant create session privilege to a user in oracle?

574

---

What is a tns file?

502

---

---

How to define a data source name (dsn) in odbc manager?

529

---

What is the scope of a local variable?

585

---

State all possible different index configurations a table can possibly have?

572

---

How to execute the package in oracle?

572

---

Is there a function to split a string in plsql?

570

---

what are the advantages of running a database in archive log mode?

1735

---

Explain rename?

554

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1787

---

What is program global area (pga) in oracle?

609

---

How to convert numbers to characters in oracle?

590

---