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:

  1. This comment has been removed by the author.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete