BI Publisher output with Pipe Delimiter
Hi oracle experts,
How to create a BI Publisher output with Pipe Delimiter ?
Desired Output example
PersonName|PersonNumber|PersonID
abcd|123|3823
I can write the SQL to add pipe delimiter in the result output but how to add pipe delimiter in the header line ? is there a option in BI Publisher settings ?
Please let me know, any help would be very much appreciated.
Many Thanks,
Shivam