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 is parameterized cursor in oracle?

574

---

How to change system global area (sga) in oracle?

570

---

What is a static data dictionary in oracle?

566

---

Why should I use oracle database?

569

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1736

---

---

What is snapshot is too old? Give and example for better understand.

1097

---

How to enter a new row into a table interactively?

544

---

Explain the dml?

590

---

How to create a new tablespace in oracle?

558

---

How to recover a dropped table in oracle?

603

---

What is the usage of synonyms?

580

---

What is the relation of a user account and a schema?

611

---

Explain how are indexes update?

619

---

what is port in oracle? how is it related to database application.

1438

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

856

---