Monday, December 19, 2011

How to make an Oracle Report Type concurrent program produce an excel friendly output?


Comma can be concatenated between the column values, however a better option is to create tab delimited file, as it takes care of commas within the string.

For this, use SQL similar to below in the report
select 'a' || chr(9) || 'b' from dual;

4 comments: