Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using Carraige Return in Odi Varaibles

mmoayedDec 20 2018 — edited Dec 21 2018

Hello all,
I want to join two variables in Packages and spool them to Cvs file, but I want to place carraige return in between for exmaple Var1 = A and Var2 = B  and Output in file should be

A

B

I have created refreshable Var3  and put this SQL

Select 'A' || chr(13) || 'B' from dual ;

or

Select var1  || chr(13) || var2  from dual ;

and I am using Odioutfile

I want to do loop for records and i am looking how to use carriage return for Windows and Unix.

BR,

Mohammed

Comments
Post Details