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 1nonverified set to 10confirmed set to 100non confirmed set to 1000audited 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 Yahoo! Search - Faster. Easier. Bingo.
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: laura pena
INET: lizzpenaorclgrp_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 - 09:22:05 CDT
