The same steps that opc.three posted here are already implemented in my project and runs smoothly. Thanks.

This is a multi platform product supporting both SQL Server and Oracle.

Finally, I opted for INTEGER instead of VARCHAR(5). The integer will store 0 or 1 instead of 'False' or...

Ed and Howard, That's true. However, the product has been running for a long time and the decision is not with me to separate the logic for different db engines...

I am afraid Varchar2 will not work in SQL Server...

Is INTEGER supported in Oracle?

Sorry, that I don't have an Oracle installation to test.

Hi Prasanth,

Fantastic article. Hats off to you. It's really comprehensive and provides useful information. Thank you very much for writing such a good article.

Thanks,

Sreeraj