Skip to Main Content

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!

Broken pipe (¦) delimiter

ArunnathJun 24 2015 — edited Jun 24 2015

Hi Friends,

I have a requirement of having broken pipe (¦) as delimiter in extract file.

I was able to achive this by executing below query in sql developer.

select 'Hello'||'¦'||'Friends' from dual;

Result : Hello¦Friends

But the same is not woking, when I executed  in sql plus login through Unix.

Result : Hello???Friends

Please help me on this.

Regards

Arunnath

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2015
Added on Jun 24 2015
11 comments
3,384 views