Supress duplicate in output file [message #443520] |
Tue, 16 February 2010 02:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
user201
Messages: 4 Registered: February 2010
|
Junior Member |
|
|
In Oracle report, there is no duplicate rows I am seeing in the report output screen but getting duplicate rows in output file generated. Can anyone tell me why?
|
|
|
|
|
Re: Supress duplicate in output file [message #443548 is a reply to message #443545] |
Tue, 16 February 2010 03:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
user201
Messages: 4 Registered: February 2010
|
Junior Member |
|
|
When tried to debug printing the message in the format trigger code it was observed that the last value of a page was carried forward to the next page and thus got the duplicate two time ie, at the end of the page and the begining of the next page
|
|
|
Re: Supress duplicate in output file [message #443581 is a reply to message #443520] |
Tue, 16 February 2010 06:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
user201
Messages: 4 Registered: February 2010
|
Junior Member |
|
|
Is there any way to supress duplicate rows in output file?
a format trigger is created and have the out put file generation logic.
out_file:= :a|| :b;
I want to skip the duplicate in format trigger.Is there a way?
|
|
|
|
|
|
Re: Supress duplicate in output file [message #561984 is a reply to message #561874] |
Thu, 26 July 2012 10:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/b0919056cea651e0a6d20a1437c20ade?s=64&d=mm&r=g) |
ollivier
Messages: 19 Registered: January 2012 Location: chihuahua
|
Junior Member |
|
|
i'ts a single query select a || ';' || b || ',' || c || text
from table to check I tried in a 19 rows table, and repeat some rows !
I resolve it. replacing DELIMITED to PDF, and I run it (info OK), then I change to DELIMITED and No duplicated Rows !
It's clear a BUG is present ! May be I need a patch !
|
|
|