Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Outputting Hex Characters from Oracle DB
Carl Hothersall wrote:
>
> Hello Everyone,
>
> I'm currently writing a PL/SQL package that outputs a file using
> UTL_FILE. For some bizarre reason, I've got to delimit the fields with
> Hexidecimal 0 (zero).
>
> Does anybody know how I can do this from an Oracle 7.3 database?
>
> Thanks in advance for you help ...
>
> Regards,
>
> Carl Hothersall.
>
> carlhothersall_at_mcmail.com
Did you try concatenating the string with chr(0) and then put?
e.g 'xyz' ||chr(0)||'abc'||chr(0)||'def'
Received on Thu Apr 23 1998 - 10:46:59 CDT
![]() |
![]() |