Still has the same problem as Dan mentioned, unless you are also
including a lookup table to indicate what the integers mean.
- "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
> I think using integers rather than bits will be easier on your where
> clause.
> It might look nice, but it will probably be a killer for performance
> when
> you starting using bit logic in queries.
>
> I'd prefer but YMMV
>
> Verified 1
> Non-Verified 2
> Conformed 3
> non-confirmed 4
> Audited 5
>
> Raj
>
>
> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
> -----Original Message-----
> Sent: Wednesday, May 07, 2003 10:22 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Looking for advise on storing bits in the Oracle database column.
> The scenario goes like this:
>
> define column statusFlag NUMBER(x)
> statusFlag can represent the following:
>
> verified set to 1
> nonverified set to 10
> confirmed set to 100
> non confirmed set to 1000
> audited set to 10000
>
> I believe this gets my point accross.... So here are my questions:
>
> What is the largest amount of bit I can set for a NUMBER(x)?
>
> How can one set and retrive the information in Oracle based on bits
> being
> set?
>
> Are there any draw backs from using too large of a NUMBER? I can
> guess one..
> wasted space.
>
>
> Thanks in advanced,
> -Lizz
>
>
>
> _____
>
> Do you Yahoo!?
> The New
> <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com>
> Yahoo! Search - Faster. Easier. Bingo.
>
> >
********************************************************************This
> e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
>
you.*********************************************************************2
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed May 07 2003 - 11:03:02 CDT
