I faced again the serious problem, that Oracle simply doesn't have a boolean column type. I need to use char(1), or smallint, or some other.
What is the best practice, how to emulate boolean values in Oracle?
(Space consumption isn't important now – but a good cooperation with java/hibernate line were important).
Best Answer
I recommend you use a SMALLINT column with a default value required (1=true, 0=false, default value = 0)