Answer Posted / 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)

i am writing a query select EmpNo from Emp how can i call in after parameter form

2129

---

Explain how one can iterate through items and records in a specified block?

1150

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1459

---

Name the different triggers associated with oracle forms having a master-detail relationship.

1004

---

What is an SQL FORMS ?

2799

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2332

---

can you convert or reverse engineer a fmx back to a fmb file?

1168

---

How to create Drill down report?

2135

---

did u received a single file or multiple files

2025

---

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4625

---

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

3002

---

Is it possible to execute a dynamic sql from forms?

1081

---

did u p prepared complex report

2005

---

List out the oracle forms configuration files?

1079

---

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1216

---