Best way to simulate Booleans

<p dir="LTR"><span lang="en-us"><font face="Calibri">I know, I know, PostgreSQL has Booleans that work very nicely.
Unfortunately,I have to create a schema that will work on Oracle</font> <font face="Calibri">as well as
PostgreSQL</font></span><spanlang="en-us"><font face="Calibri">, by which I mean that a single set of
Java/JDB</font><fontface="Calibri">C code has to work with both databases.</font></span><span lang="en-us"> <font
face="Calibri">Ihave a</font></span><span lang="en-us"><font face="Calibri">n</font></span><span lang="en-us"><font
face="Calibri"></font></span><spanlang="en-us"> <font face="Calibri">XML</font></span><span lang="en-us"> <font
face="Calibri">meta-schemathat enables me to generate appropriate DDL</font><font face="Calibri">;
that</font></span><spanlang="en-us"> <font face="Calibri">handles</font> <font face="Calibri">all</font> <font
face="Calibri">theINTEGER vs. NUMBER(m,n) stuff</font></span><span lang="en-us">.<font
face="Calibri"></font></span><spanlang="en-us"> <font face="Calibri">But</font></span><span lang="en-us"><font
face="Calibri"></font></span><spanlang="en-us"> <font face="Calibri">Oracle</font></span><span lang="en-us"> <font
face="Calibri">simply</font></span><spanlang="en-us"> <font face="Calibri">has no</font></span><span lang="en-us">
<fontface="Calibri">Boolean</font></span><span lang="en-us"><font face="Calibri">s</font></span><span
lang="en-us"><fontface="Calibri">, so I will have to resort to</font> <font face="Calibri">some more</font></span><span
lang="en-us"><fontface="Calibri"></font></span><span lang="en-us"> <font face="Calibri">or</font></span><span
lang="en-us"><fontface="Calibri"></font></span><span lang="en-us"> <font face="Calibri">less ugly
alternative</font></span><spanlang="en-us">.<font face="Calibri"> I am ho</font><font face="Calibri">ping that others
herehave had to deal with this and can suggest an approach that will be minimally loathsome.</font></span><p
dir="LTR"><spanlang="en-us"><font face="Calibri"><VENT></font><font face="Calibri">God I hate
Oracle</font></span><spanlang="en-us"><font face="Calibri">…</font></span><span lang="en-us"><font
face="Calibri"></VENT></font></span><spanlang="en-us"></span><p dir="LTR"><span lang="en-us"></span><span
lang="en-us"><fontface="Calibri">-- </font></span><p dir="LTR"><span lang="en-us"><font face="Calibri">Peter
Headland</font></span><pdir="LTR"><span lang="en-us"><font face="Calibri">Architect - e.Reports</font></span><span
lang="en-us"></span><spanlang="en-us"></span><span lang="en-us"></span><p dir="LTR"><span lang="en-us"></span><span
lang="en-us"><fontface="Calibri">Actuate Corporation</font></span><p dir="LTR"><span lang="en-us"></span>