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);

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

779

---

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

754

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2590

---

What happens to the current transaction if a ddl statement is executed?

767

---

Difference between oracle's plus (+) notation and ansi join notation?

834

---

various types of hints and their usage

2368

---

What are operators in oracle?

772

---

What are the different types of database objects?

730

---

What is meant by recursive hints in oracle?

826

---

What is a schema in oracle?

759

---

What is a data dictionary and how can it be created?

819

---

How to import one table back from a dump file?

794

---

What is an Oracle Instance?

876

---

What would you do with an in-doubt distributed transaction?

1704

---

What is a tns file?

717

---