Re: In what type in Oracle it is possible to write down binary <8bit?
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 03 Oct 2008 13:11:20 -0700
Message-ID: <1223064677.799475@bubbleator.drizzle.com>
>
> 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 --
Date: Fri, 03 Oct 2008 13:11:20 -0700
Message-ID: <1223064677.799475@bubbleator.drizzle.com>
Mark D Powell wrote:
> 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 --
Don't forget:
NUMTOHEX
NUMTOHEX2
and
RAWTONHEX
http://www.psoug.org/reference/builtin_functions.html
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Oct 03 2008 - 15:11:20 CDT