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)

List the different types of columns in oracle reports.

1004

---

Can we invoke one form from another in a multi-forms application?

1133

---

Explain the various types of oracle report?

1076

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2023

---

if u want to delete all these detail block etc what will happen in form

1989

---

What do you understand by lov?

1037

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1978

---

difference between global n context sensitive segments?

2676

---

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

1888

---

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

1000

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2216

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1301

---

how do u place it in required folder

1934

---

Is it possible to execute a dynamic sql from forms?

1073

---

what are bind variables?

1088

---