Posts Tagged ‘PL/SQL’




Enforce Data Integrity With Check Constraints

Sunday, November 23, 2008 10:25 No Comments

I came across some code the other day that simply horrified me. I was looking at a table that had a field name which implied it stored a boolean value (e.g. IS_LAUGHABLE). The field type is defined as a char(1), allows NULL values and defined no default value. Looking at the data in the column [...]

This was posted under category: Database, Java Tags: , , ,