Hi! When looking in Oracle, double type fields have been written as binary_double. Is this normal? What alternatives are there?
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
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.
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 ?
