set colsep ,
set feedback off
set heading off
set trimout on
set pagesize 0
set linesize 1000
spool /scripts/ALI_20160715_OUTPUT.csv
select '"' ||REGNO|| '","' || CREDIT_CODE || '","' || ENTNAME || '","' ||NAME|| '","' || CERNO || '"' from ALI_20160715_OUTPUT;
select '' ||REGNO|| ',' || CREDIT_CODE || ',' || ENTNAME || ',' ||NAME|| ',' || CERNO || '' from ali_20160715_output_cerno;
spool off;
set feedback off
set heading off
set trimout on
set pagesize 0
set linesize 1000
spool /scripts/ALI_20160715_OUTPUT.csv
select '"' ||REGNO|| '","' || CREDIT_CODE || '","' || ENTNAME || '","' ||NAME|| '","' || CERNO || '"' from ALI_20160715_OUTPUT;
select '' ||REGNO|| ',' || CREDIT_CODE || ',' || ENTNAME || ',' ||NAME|| ',' || CERNO || '' from ali_20160715_output_cerno;
spool off;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30345407/viewspace-2122248/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
oracle 回收表空间的数据文件大小
请登录后发表评论
登录
全部评论
