Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Double writes to oracle DB as binary double

citronmelisa
8 - Asteroid

Hi! 

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

 

3 REPLIES 3
TheOC
15 - Aurora
15 - Aurora

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

 

 


Bulien
citronmelisa
8 - Asteroid

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
15 - Aurora
15 - Aurora

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


Bulien
Labels