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
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What do you understand by lov?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
In what situation u create the BPA.
What are the various configuration files that are used by oracle forms?
how do u place it in required folder
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
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
i am writing a query select EmpNo from Emp how can i call in after parameter form
did u p prepared complex report
what is the difference between call_form, new_form and open_form?
Name the different triggers supported by oracle reports and their firing order.
List out the oracle forms configuration files?
Name the different triggers associated with oracle forms having a master-detail relationship.
Why oracle forms required?