set echo off;
set feedback off;
set verify off;
set term off;
set trimspool on;
set linesize 5000;
set newpage none;
set heading off;
set serveroutput off
ALTER SESSION SET NLS_TIMESTAMP_FORMAT='YYYY/MM/DD HH24:MI:SS';
column log_date new_value log_date_text noprint
select to_char(sysdate,'yyyymmdd') log_date from dual;
SPOOL /tmp/export_test_&log_date_text..csv
select '
"TEST COLUMN"'
From DUAL
UNION ALL
select
TEST_COL
FROM TEST_TABLE;
spool off;
quit;
ORACLE 导出检索结果
最新推荐文章于 2024-03-04 19:20:37 发布