I know Oracle allows column definitions of INTEGER for compatability with other databases. This then creates columns with definition of NUMBER(38). How wasteful is this? Would I be better finding out from my third party what definition these columns really should be e.g. NUMBER(4)????
Not exists differense between INTEGER and NUMBER(38) on internal oracle level.
Oracle convert INTEGER --> NUMBER(38) in any way.
in PL/SQL (not in SQL) exists differense between NUMBER(38) and BINARY_INTEGER and PLS_INTEGER only.
Yes .. so what I need to know is how wasteful is - or what are the pitfalls of - making NUMBER columns too long?