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 having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1978

---

What is the difference between bind and lexical parameter?

1076

---

Explain the different levels at which oracle form services interact.

1047

---

How can we generate report output in excel format?

991

---

how report can be generated if we have the database designed in oracle 10g?

1883

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1889

---

What is an SQL FORMS ?

2786

---

what is tripstop report?

1832

---

all steps of bitmap report?

2352

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1686

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2225

---

hiding item in report how like that properly,thats manually but at runtime i want to do

3229

---

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

1122

---

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

1161

---

What is a canvas in oracle forms?

1065

---