Double writes to oracle DB as binary double

[citronmelisa]

Hi! 

When looking in Oracle,  double type fields have been written as binary_double. 
Is this normal? What alternatives are there?

[TheOC · Accepted solution]

Hi @citronmelisa 
You could also output your decimal values as a FixedDecimal, or Float.
Alternatively, you can force the output type using a formula In-DB tool. 

So I can best have a look into this for you, what data type is expected?

Kind Regards,

Owen

[citronmelisa]

Thank you, TheOC!
Currently I was wondering just whether this is the default and what are other options. 
Couldn't amounts (that have just 2 decimal places in general) be stored as NUMBER ?

[TheOC · Accepted solution]

Hey @citronmelisa 
No problem at all!
My knowledge of Oracle is limited in places, but you're totally right it could be stored as NUMBER. 

I believe if you create the table/schema beforehand in Oracle, when you output to it from Alteryx it should respect the set datatype. This way you could force it to be a NUMBER type if that proves beneficial.

Kind Regards,

Owen