Which one is better to use ?
I have a dilema here. I am on Oracle 92.
When i create a field in a table that is going to use NUMBER data, which one can i use ?..i read some where that NUMBER datatype can hold both INTEGER and DECIMAL types..is it true ?..
or should i use NUMBER (p,s) for Decimals and just NUMBER for INTEGERS ?...
Depends on what numbers you want to store -- if you need decimal places, then specify them.
The precision and scale are simply check constraints that restrict the maximum p & s that the column will store. It makes no difference to how many bytes are used for storage.
Click Here to Expand Forum to Full Width