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 are the uses of synonyms?

1138

---

State any two functions of oracle?

1046

---

How to find the duplicate rows count from employees table in oracle?

1095

---

What is dual table oracle?

986

---

material view and view disadvantages?

1079

---

What is the data type of dual table?

995

---

Difference between cartesian join and cross join?

1049

---

What happens to the current transaction if the session is ended?

1098

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1068

---

Point out the difference between user tables and data dictionary?

985

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2625

---

Is there a function to split a string in plsql?

1064

---

How to invoke the original export import utilities?

1064

---

What is Virtual Private Database in Oracle?

1091

---

Explain table?

1121

---