Re: Is there a bitfield type field in oracle?

From: tb <>
Date: Wed, 30 Jan 2008 09:53:21 -0800 (PST)
Message-ID: <>

Hello Dean,

 sorry, a bitmap typ doesn't exist. Solution 1) not realy a good idea
(sorry 2008 have 366 days).

Solution 3) looks like a relational database. Go one step more.

REF_TBL_TRAIN (ID, NAME) reference table for all trains
(1,'TRAIN A')
(2,'TRAIN B')
(3,'TRAIN C')

REF_TBL_WEEK (ID,WEEK) reference table for all weeks in the year (54 entries for one year)
(1,'Week 1') ... (52,'Week 52')

REF_TBL_DAY_WEEK (ID,RUNNING_DAY) reference table to specify the days a train is running (create only combinations you need)
(1,'YYYYYYY'), (2,'YYYYYYN') or something more simpler.

The table TRAIN_HELP(ID_TRAIN,ID_WEEK,ID_TBL_WEEK) contains 3 values for the 3 reference tables. If there is no entry use a good default value.
Most trains will run monday till friday. A better solutions for holidays is the next step.

Best regards
thomas Received on Wed Jan 30 2008 - 11:53:21 CST

Original text of this message