| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Displaying Oracle's BLOB or Sybase's binary objects as hex digits
A copy of this was sent to "Ludwig Cheng" <NOSPAM.Ludwig.Cheng_at_unn.unisys.com> (if that email address didn't require changing) On Mon, 8 Jun 1998 17:43:33 +0200, you wrote:
>I'm using MsAccess97 as a front-end via ODBC to either Oracle or Sybase.
>While MsAccess can handle the simple data types (char, integer, floats etc)
>with ease, it doesn't offer much support for binary objects as Oracle's BLOB
>or Sybase's Binary. Are there any ways to display such objects in MsAccess
>as hex digits or writing them to a file for a hex dump?
>
>Thank you in advance
>
Easy enough in Oracle, to get the first 2000 characters in hex:
select id, rawtohex( dbms_lob.substr(theblob,2000,1) ),
dbms_lob.getlength( theblob )
from blobs
/
use rawtohex on dbms_lob.substr()
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jun 08 1998 - 00:00:00 CDT
 |
 |