Development #databases 1 min

Oracle 8i and case sensitivity

Translation of the original in Catalan. Read it in: CatalàCastellano

As popular culture already says, you won't go to bed without knowing 2 or 3 more things. The last thing that has left me stunned is this one:

Oracle 8i is case sensitive for the field names but not for table names.

So there you go folks, now it turns out Oracle is case sensitive in the names of a table's fields, but not in the table name. This silly thing has made me lose days and days of testing with data models :'(