Re: DEFINING AND WORKIG WITH BINARY COLUMNS
From: DanHW <danhw_at_aol.com>
Date: 18 Sep 1998 02:55:12 GMT
Message-ID: <19980917225512.03944.00000908_at_ng99.aol.com>
Date: 18 Sep 1998 02:55:12 GMT
Message-ID: <19980917225512.03944.00000908_at_ng99.aol.com>
>i'd like to :
>
>1) Define a binary column in Oracle 7.1.5 .
>
>2) Perform assignment into that column for example:
> i want that the 14th bit will be equal to '1' and the 6th be
>equal to '0' .
>
>3) Perform logical functions on taht field with another one alike
>(AND,OR) .
>
>thanks boaz g.
>
>
Oracle does not have a binary data type. You have a few options... use integers and write your own bit operators...or build a varchar2 column wide enough. However, it takes up basically as much space to have a varchar2(5) as 5 varchar2(1) and the logic is a lot simpler with 5 varchar2(1) columns.
good luck
Dan Hekimian-Williams Received on Fri Sep 18 1998 - 04:55:12 CEST