Re: storing boolean value

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Mon, 16 Jul 2001 16:40:30 -0700
Message-ID: <9ivtto$1cr$1@spiney.sierra.com>

absolutely use number(1) rather than varchar2(1)

if it's a number, then when you do your statistics ( recency/frequencies) you can use sum()
rather than (sum(decode()))

"Ian Ledzion" <ian.ledzion_at_lgxbow.com> wrote in message news:9iuug4$nqr$1_at_rex.ip-plus.net...
> Not sure about efficient, but I use NUMBER (1), 0=FALSE, 1=TRUE.
>
>
> <lagaf_at_iname.com> wrote in message

news:tl5ujiqlae2e8e_at_corp.supernews.com...
> > Hello,
> > Simple newbie question: what column datatype would you use to store a
> > boolean value ? Number(1) ? char(1) ? Other ?
> > Which one is the most efficient ?
> > Thanks!
> > L.
> >
> > --
> > Posted via CNET Help.com
> > http://www.help.com/
>
>
Received on Mon Jul 16 2001 - 18:40:30 CDT