RE: Using bits to store information in the database.

From: Orr, Steve <sorr_at_rightnow.com>
Date: Wed, 07 May 2003 09:47:28 -0800
Message-ID: <F001.005929BF.20030507094728@fatcity.com>

Whilst not relational it's oft used by the almighty Oracle. Go to $ORACLE_HOME/rdbms/admin and grep bitand *.*

Check out Metalink note 119451.1 for a more comprehensive review.

Steve Orr
Bozeman, Montana

-----Original Message-----
Sent: Wednesday, May 07, 2003 10:03 AM
To: Multiple recipients of list ORACLE-L Importance: High

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.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 - 12:47:28 CDT