Re: In what type in Oracle it is possible to write down binary <8bit?
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 3 Oct 2008 06:22:32 -0700 (PDT)
Message-ID: <1f20e29d-af96-4add-b16a-1844b10a74fc@j22g2000hsf.googlegroups.com>
Date: Fri, 3 Oct 2008 06:22:32 -0700 (PDT)
Message-ID: <1f20e29d-af96-4add-b16a-1844b10a74fc@j22g2000hsf.googlegroups.com>
On Oct 3, 6:47 am, "gym dot scuba dot kennedy at gmail"
<kenned..._at_verizon.net> wrote:
> <mmf.stave..._at_gmail.com> wrote in message
>
> news:e0ff1b3e-4f77-41dd-b628-4123954f2b47_at_s50g2000hsb.googlegroups.com...> Hello,
>
> > In what type in Oracle it is possible to write down binary <8bit?
>
> > Thanks,
>
> > St. Mr
>
> That would be a raw column or a blob column depending upon size.
> Jim
If you are going to try to work with bits via Oracle you might find the following SQL functions of interest:
HEXTORAW
RAWTOHEX
BITAND
BIN_TO_NUM
as well as the functions provided by the UTL_RAW package.
HTH -- Mark D Powell -- Received on Fri Oct 03 2008 - 08:22:32 CDT