How much space does Oracle allocate on a column if the datatype is number and no precision/scale is specified?
Printable View
How much space does Oracle allocate on a column if the datatype is number and no precision/scale is specified?
The data type number has precision and scale. the precision can range from 1-38 and the scale can range from -84 to 127. If no specification was made, then oracle would allocate 4bytes for number.
Hope this would answer your question.
Sam