Answer Posted / ravi kant yadav

Delete from table_name where ROWID not in ( select
max(rowid) from table group by duplicate_values_field_name);

Regards
ravi

In support project one ticket alloted which steps follows manualy tell me ?

2668

---

What are do's and dont's of Interface?

2433

---

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

2274

---

what is pay run id ?

2203

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2395

---

Are you familiar with internet architecture of oracle apps 11i?

1070

---

How can you achieve loose coupling in soa framework?

1233

---

Can you explain the difference between architecture followed in 10g & 11g?

1072

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2267

---

how can i print random rows in plsql table

2507

---

Can we create tables in apps schema?

1148

---

tell me the scenarios of the independent in reports

2518

---

What are the different components you should consider while defining a responsibility in oracle apps?

1088

---

What is oracle soa suite and what are its different components?

1223

---

What is instead of trigger in where we will use?

1179

---