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