Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Outputting Hex Characters from Oracle DB

Re: Outputting Hex Characters from Oracle DB

From: Ganesh Kini <gkini_at_epnet.com>
Date: Thu, 23 Apr 1998 11:46:59 -0400
Message-ID: <353F6273.31BE@epnet.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US