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 are bind variables?
List the different types of columns in oracle reports.
did u received a single file or multiple files
Can we invoke one form from another in a multi-forms application?
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
how do u place it in required folder
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
What is an SQL FORMS ?
What is the difference between bind and lexical parameter?
How can we expand Parameter Form Canvas on Reports 6i?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
i am writing a query select EmpNo from Emp how can i call in after parameter form
Is it possible to have multiple layouts in a report?