Answer / sandeep

the above answer will work ifonly one dplicate row is there,
if there are more than one duplication.
then

delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name having count(*)>1)

Answer / jagan

delete from tablename a where rowid not in(select max(rowid)
from tablename b where a.rowid=b.rowid)

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

0 Answers  

---

Use the add_group_column function to add a column to record group that was created at a design time?

2 Answers  

---

How to call Report from other Report ?

1 Answers  

---

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

2 Answers  

---

what is difference between group above and group left report

0 Answers   Oracle,

---

Is it possible to split the printpreviewer into more than one region?

1 Answers  

---

What is a visual attribute?

1 Answers  

---

What is the Maximum allowed length of Record group Column?

2 Answers  

---

i want print character reports in 10g application reports pl help me my id is yoga.roh@gmail.com

3 Answers  

---

what are the different objects that you cannot copy or reference in object groups?

1 Answers  

---

What is system.coordination_operation?

1 Answers  

---

What are the built-ins used for finding object ID functions?

2 Answers  

---