# Oracle Number Format in Dremio 23.2.2 **URL:** \ **Category:** Uncategorized\ **Created:** [October 18, 2023, 8:29pm UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098 "2023-10-18T20:29:56Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![ericathm](https://avatars.discourse-cdn.com/v4/letter/e/0ea827/32.png) [@ericathm](https://community.dremio.com/u/ericathm)\ **Post date:** [October 18, 2023, 8:29pm UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098/1 "2023-10-18T20:29:56Z")
Hi there, I have an Oracle column with the data type NUMBER that returns a value of 0.0100015. However, Dremio does not recognize this data type and is returning the truncated value as 0.010002. Could anyone please help me with this issue? Dremio 23.2.2-202307280452300417-9276e770 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/6/66db7611c26e5e5367dc93dfcbb2b82a588da0ce.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/a626c148955cd432d22be9dd9266d5fb78850f9c.png) ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [October 23, 2023, 3:14am UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098/2 "2023-10-23T03:14:16Z")
@ericathm Let us start with the push down that is sent to Oracle, can you please provide us with the job profile that will tell us the pushdown, meanwhile, can you please try external query and see if that brings the right value? > **[Querying External Data Sources | Dremio Documentation](https://docs.dremio.com/24.1.x/sonar/data-sources/databases/external-queries/#enabling-users-to-perform-external-queries-dremio-160)** > > Dremio enables users to run external queries, queries that use the native syntax of the relational database, to process SQL statements that are not yet supported by Dremio or are too complex to convert. Dremio supports external queries for the... ---
**Author:** ![ericathm](https://avatars.discourse-cdn.com/v4/letter/e/0ea827/32.png) [@ericathm](https://community.dremio.com/u/ericathm)\ **Post date:** [October 24, 2023, 3:13pm UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098/3 "2023-10-24T15:13:29Z")
Hello @balaji.ramaswamy , thanks for the help i tried to use an external query , without transformations : ```auto SELECT VAL_PRECO_UNITARIO FROM table(BDH.external_query('SELECT VAL_PRECO_UNITARIO as VAL_PRECO_UNITARIO FROM CETIPH.OPERACAO where NUM_ID_OPERACAO_H = 6887275048')); ``` and watching the result, i realized that Dremio always convert the field to DECIMAL (38,6) Dremio doesn’t return the result with all precisions , same as the source ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/8/8796a5066a1b62a98f8e44556ac0161917cbc40f.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/4/4bffcc8318e3c504b8515577bd8a5f41c85e4357.png) BUT, when I try to convert the field to precision 8, it returns correctly However, the table has a large volume and is not a possible alternative for us to use it like this Because, for this conversion, all the volume of the table will be taken to Dremio, instead of being processed in Oracle ```auto SELECT VAL_PRECO_UNITARIO FROM table(BDH.external_query('SELECT cast(VAL_PRECO_UNITARIO as decimal(38,8)) as VAL_PRECO_UNITARIO FROM CETIPH.OPERACAO where NUM_ID_OPERACAO_H = 6887275048')); ``` ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/7/7fc1cb6377c68e86c3d46207281ad080271d7610.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/9/9063c98fa11d206ef862f68c95ee967ccf1dbd3d.png) Is there any internal configuration in Dremio to remove the forced conversion of Decimal (38,6) when the data type is number in Oracle? thanks a lot ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [October 25, 2023, 11:17pm UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098/4 "2023-10-25T23:17:24Z")
@ericathm It is hard to understand from the screenshot, ca you please send us the profile? ---
**Author:** ![ericathm](https://avatars.discourse-cdn.com/v4/letter/e/0ea827/32.png) [@ericathm](https://community.dremio.com/u/ericathm)\ **Post date:** [October 30, 2023, 9:28pm UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098/5 "2023-10-30T21:28:29Z")
@balaji.ramaswamy follow the attachments, thanks [normal.zip](https://community.dremio.com/uploads/short-url/g9jNvCaTVLhDKqi4ysqB31kUUvj.zip) (12,1,KB) [convert.zip](https://community.dremio.com/uploads/short-url/hYeCuZiL3gC07VSRiQG3eVl3bzA.zip) (12,2,KB) ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [November 1, 2023, 5:37am UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098/6 "2023-11-01T05:37:26Z")
@ericathm Having trouble opening the normal profile. Let us do this, is it possibleto send the “CREATE TABLE” DDL for `BASEH.OPERACAO` from SQL Developer or SQL Plus. Best is to recreate the issue so we can find a workaround or solution ---
**Author:** ![ericathm](https://avatars.discourse-cdn.com/v4/letter/e/0ea827/32.png) [@ericathm](https://community.dremio.com/u/ericathm)\ **Post date:** [November 1, 2023, 8:38pm UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098/7 "2023-11-01T20:38:22Z")
@balaji.ramaswamy of course ```auto CREATE TABLE "BASEH"."OPERACAO" ( "NUM_ID_OPERACAO_H" NUMBER, "NUM_OPERACAO_PARTE" VARCHAR2(10 BYTE), "NUM_OPERACAO_CPARTE" VARCHAR2(10 BYTE), "COD_OPERACAO" VARCHAR2(16 BYTE), "DAT_OPERACAO" DATE, "QTD_OPERACAO" NUMBER, "VAL_PRECO_UNITARIO" NUMBER) ``` ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [November 7, 2023, 9:38pm UTC](https://community.dremio.com/t/oracle-number-format-in-dremio-23-2-2/11098/8 "2023-11-07T21:38:04Z")
@ericathm Thanks, let me get back on this