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 different types of record groups in oracle? Explain each of them

1070

---

Why do we need integrity constraints in a database?

1076

---

What are the tools for Oracle ?

1108

---

How to download oracle database 10g xe?

1066

---

How to connect to a remote server?

1188

---

Explain what are clusters?

1156

---

Explain the use of parfile option in exp command.

1138

---

Can you tell me how to add new column in existing views?how?How is possible?

1515

---

Explain the function of optimizer in oracle?

1198

---

How to get a list of all background sessions in the database?

1040

---

How to drop a stored function?

1183

---

What is save point in oracle database?

1365

---

How do I know if oracle is installed on windows?

984

---

Write a syntax for update query in oracle?

1074

---

What are the logical operations?

1170

---