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
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