how to eliminate duplictes in column except group and
section?

Answer Posted / jagan

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

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1449


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

1598


what is difference between group above and group left report

3202


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

1482


what are the new features introduced in oracle form services in 11g release 2?

582






Is it possible to execute a dynamic sql from forms?

596


What do you understand by oracle forms and why are they required?

556


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

1598


where do u put the report file

1650


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

633


what are the oracle forms services components include?

556


What are the various configuration files that are used by oracle forms?

568


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1553


how do u place it in required folder

1475


what is the difference between call_form, new_form and open_form?

721