-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|