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

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

603


What do you understand by lov?

538


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

820


In what situation u create the BPA.

1751


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

534






how do u place it in required folder

1429


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

1408


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

1269


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

1575


did u p prepared complex report

1584


what is the difference between call_form, new_form and open_form?

690


Name the different triggers supported by oracle reports and their firing order.

562


List out the oracle forms configuration files?

530


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

470


Why oracle forms required?

534