Skip to Main Content

SQL Developer

excel.xml format does not support empty numbers - the output is 0 instead of null

In Version 21.2.1.204 (Build 204.1703) there is problem with export data to “excel.xml” format:
If there is an empty field in the column with numeric format in the database, then after export null is replaced by the value 0 in the xml file.
This seriously falsifies the output data.
This is exactly the same problem as reported in 2014: https://community.oracle.com/tech/developers/discussion/comment/12553936
Regards
Marek

Comments
Post Details
Added on Sep 3 2021
0 comments
100 views