SQL & PL/SQL

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!

Not Able To Spool Correct Data

Rajan SwMar 7 2016 — edited Mar 9 2016

Hi,

I have a requirement to spool the data in pipe separated and if the data it self contains the pipe i need to replace this | to '¦' .

When I am checking in the sql developer for this query, this is coming fine but the same query if I execute on command prompt this is not getting replaced ...

Any thing else I have to change for the command prompt ...

SELECT CRED_VALUE,REPLACE(cred_value,'|',CHR(49830)) FROM cust_auth_creds WHERE ip_idfr=500000015057;

I am using the following oracle version

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

"CORE 11.2.0.1.0 Production"

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

OS version is

Linux SandPowerMocky2 3.2.0-45-generic #70-ubuntu SMP Wed May 29 20:12:06 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

I will aprreciate any thoughts on this Command Line.png sql Developer.png

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2016

Added on Mar 7 2016

10 comments

1,959 views