Export function of the AQT version 8.2.2 Extended Edition
To load table I'm using the Data loader Tool - Load Data from Query.
On the query text I placed my query, by using Preview can see the expected
data, then run Load process, the target table loaded with all rows, but
DECIMAL field is loosing decimals numbers and display only 00 .
Source field defined as DECIMAL (7,2), on the target table field defined as
DECIMAL (9,2)
I used different CAST functions to resolve it , but result same.