Need to store 2457431456.6443981482 with 10 scale digits but no matter what precision and scale I use when retrieving number oracle rounds before and up to the 8th digit. Even when define as number(38,18) this does not help. I can retrieve entire 10 digit scale if use to_char but we need it sent back to application as actual number datatype NOT a character, otherwise would actually store as varchar2. Oracle support is no help with this. Is there a setting to actually pull field from table as numeric datatype that will display original number inserted WITHOUT conversion to TO_CHAR?