From Access Boolean to Oracle Number

From: Tony Pich <apich_at_viviance.com>
Date: Tue, 5 Oct 1999 12:17:04 +0100
Message-ID: <7tcj57$r2u$1@diana.bcn.ttd.net>

Hi:

I have many applications which use Access through ODBC. In Access I have some fields defined as boolean. When converting these databases to Oracle, the boolean fields are turned into number fields.

This causes me a lot of trouble, because my applications are querying the databases with 'True/False' values for the boolean fields. Is there some way I can make Oracle deal with the 'True/False' values for a number field like if they were '0/1', or do I have to modify manually all my applications ?

Thanks a lot,

Tony Pich Received on Tue Oct 05 1999 - 06:17:04 CDT