The Oracle Datatype Number table describes how data is returned, based on the number_mode parameter and scale value of the Oracle number datatype.
Scale |
number_mode = 0 |
number_mode = 1 |
number_mode = 2 |
|---|---|---|---|
scale = 0 |
If 0 <= precision <=9, return as shown in Conversion for Oracle datatype number table, else return data as float. |
If 0 <= precision <=9, return as shown else if precision is valid, return data as numeric, else return data as float. |
If precision is valid, return data as numeric, else return data as float. |
scale !=0 |
return data as float. |
If valid precision and scale, return data as numeric, else return data as float. |
If valid precision and scale, return data as numeric. |