如何将FastExport配置为不导出科学符号中的浮点数？

Question

我们正在尝试将快速导出创建的文件加载到oracle数据库中。

但是，浮点数列的导出方式如下：1.47654345670000000000 E010。

如何将快速导出配置为像这样的导出：14765434567。

我们将通过SQL*Loader将导出的文件加载到oracle数据库中。

更新：

最初，它在向cast(XXXX as varchar(500))提供的查询中使用: FastExport。

Answer 1

解决方案是使用cast(cast(FLOAT_VAL as FORMAT 'Z(16)') as varchar(16))

若要使其全部为数字和左填充空格：cast(FLOAT_VAL as FORMAT 'Z(16)')

若要移除填充：cast(<VALUE> as varchar(16))

另一种解决方案：trim(cast(FLOAT_VAL as FORMAT 'Z(16)'))

.logtable sysdba.TABLE_NAME;
.run file XXX/XXXXX/XXXXXX/XXXXX.btq;
.begin export;
.export outfile /XXX/XXX/XXX/XXX/YYYYYYY.YYYYYYYYYY_19000100-19000100 MODE RECORD FORMAT TEXT;
SELECT cast( cast(cast(FLOAT_VAL as FORMAT 'Z(16)') as varchar(16))
          || case when XXXXXXXXXXXXXXXXXXXX      is null then '|' else cast(XXXXXXXXXXXXXXXXXXXX      as varchar(500)) || '|' end
          || case when XXXXXXXXXXXXXXXXXXXXX     is null then '|' else cast(XXXXXXXXXXXXXXXXXXXXX     as varchar(500)) || '|' end
          || case when XXXXXXXXXXXXXXXXXXXXXXXXX is null then '|' else cast(XXXXXXXXXXXXXXXXXXXXXXXXX as varchar(500)) || '|' end
          || case when XXXXXX                    is null then '|' else cast(XXXXXX                    as varchar(500)) || '|' end
          || case when XXXXXXXXXX                is null then '|' else cast(XXXXXXXXXX                as varchar(500)) || '|' end
          || case when XXXXXXXXXXXXXXX           is null then '|' else cast(XXXXXXXXXXXXXXX           as varchar(500)) || '|' end
          || case when XXXXXXXXXXXXXXXXXXXXX     is null then '|' else cast(XXXXXXXXXXXXXXXXXXXXX     as varchar(500)) || '|' end
          || case when XXXXXXXXXXXXXXXX          is null then '|' else cast(XXXXXXXXXXXXXXXX          as varchar(500)) || '|' end
          || case when XXXXXXXXXXXXXXXXX         is null then '|' else cast(XXXXXXXXXXXXXXXXX         as varchar(500)) || '|' end
          || case when XXXXXXXXXXXXXX            is null then '|' else cast(XXXXXXXXXXXXXX            as varchar(500)) || '|' end
          || case when XXXXXXXXXXXXXXX           is null then '|' else cast(XXXXXXXXXXXXXXX           as varchar(500))        end
       as char(360))
  from YYYYYYY.YYYYYYYYYY;
.end export;