使用SQLcl绝对是正确的方法。建立一个脚本（或一组脚本），运行所有您希望将数据导出到CSV文件的查询。下面是一个示例脚本，它将连接到数据库，设置格式，生成文件，然后断开连接。
该脚本将使用如下命令启动：

sql /nolog @start_export.sql

start_export.sql示例内容：

--Connect to the database
connect <username>/<password>@<TNSalias>

--Set format to CSV for results from SELECT statements
set sqlformat csv;
--Turn off the number of rows that get returned by the select
set feedback off;

--Create 1st report
spool report1.csv

select japolip_wnupo wnupo,japolip_socpo socpo,japolip_jasccdp_winag winag,japolip_wnpro wnpro,jaagenp_ainag,jaagenp_nomag
from sunapicf.japolip japolip
left join sunapicf.jaagenp jaagenp on jaagenp_winag = japolip_jasccdp_winag;

--Create 2nd report
spool report2.csv

select distinct socpr socpo,jaagenp.jaagenp_winag winag,JACRCFP.JACRCFP_wnpro wnpro,jaagenp_ainag,jaagenp_nomag
from sunapicp.JACRCFP JACRCFP
left join 
(
select japrodp_wnpro,socpr
from sunapicp.japrodp japrodp
cross join xmltable('//JAPRODP' passing xmltype(japrodp.ficxml) columns SOCPR)
) japrodp on japrodp.japrodp_wnpro = JACRCFP.JACRCFP_wnpro
left join sunapicf.jaagenp jaagenp on jaagenp.jaagenp_winag = jacrcfp.jacrcfp_winit;

--Disconnect
exit