It can be challenging to pick the right data type. You may start with a text field to store your email addresses and then later realize there is an Email type. Maybe you picked DateTime when really ...

Further investigation has shown that the type NUMBER in oracle is I think floating point when there's no precision/scale set, although oracle seems to have no issue when doing a select *. Likewise ...