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

Give the various exception types.

942

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1590

---

Can a parameter be passed to a cursor?

1051

---

How to empty your oracle recycle bin?

979

---

How to execute a stored program unit?

1003

---

How to apply filtering criteria at group level in oracle?

985

---

What are advantages of dateset in datastage?

2198

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1894

---

What are the oracle built-in data types?

1008

---

What is dual table oracle?

923

---

Explain a private synonyms?

980

---

How to start an oracle instance?

950

---

How do I manually uninstall oracle client?

1023

---

Differentiate between pre-select and pre-query?

1051

---

How do we get field details of a table?

931

---