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