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

Home -> Community -> Usenet -> c.d.o.tools -> Re: BLOBs

Re: BLOBs

From: Gordon Twaddell <gwtwaddell_at_eoriginal.com>
Date: Wed, 20 Jun 2001 08:31:38 -0400
Message-ID: <cD0Y6.2$605.235@client>

You could always try saving the BLOB to a file, then try using the "file" command on a UNIX system or failing that, using "od" to look for a hint.

"root" <justin_at_justin.com> wrote in message news:3B2FEFD4.76518AC9_at_justin.com...
> Hi. I have a quick question.
>
> I have enherited a table that has a column that contains BLOBs.
>
> Is there any way of finding out what kind of data this contains?
>
> Obviously, SQLplus can't display it, and even if I get the data out
> using a perl program or the like, I have no way of knowing what format
> the data is in.
>
> I'm new to this stuff, and have no access to the programs that would
> have created the BLOBs in the first place.
>
> Thanks for any pointers.
>
> justin
>
Received on Wed Jun 20 2001 - 07:31:38 CDT

Original text of this message

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