SQL: Spool in Hex ?? like select HEX(DeptNo),Desc from Emp;

From: Frank Clever <Frank.Clever_at_gmx.de>
Date: 2000/09/21
Message-ID: <01c02403$5ea753e0$LocalHost_at_default>#1/1


Hello...
I am looking for a function or tool to spool some data from an Oracle
(7.3.4 NT Version) Database to a file

See script down
The first Statement work very well, but I don't find a way to do the second Statement...
I tried allready TO_CHAR, HEXTORAW ..... Has somebody any ideas ???
(Maybe there is allso a Package to do this)
Thanks for all help.

Frank

connect user/password
spool c:\temp\spool.log

select DeptNo,Desc from Emp;

10, "Fireworks"
20, "Police"
30, "Nobody"

select HEX(DeptNo),Desc from Emp;

0x0A, "Fireworks"
0x14, "Police"
0x1E, "Nobody"

spool off;

disconnect; Received on Thu Sep 21 2000 - 00:00:00 CEST

Original text of this message