1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Set linesize 2000
set feedback off
set flush off
set heading off
set headsep off
set timing off
set pagesize 0
set recsep off
set termout off
set trimspool on
set verify off
set wrap on
set pause off
COLUMN l_file new_value l_file
column NUMCLI new_value NUMCLI -- j'avais cette colonne, ici un exemple ce n'est pas avec serveur mais juste num client
select NUMCLI from acli where NUMCLI='942110' AND NUMCSS='10';
SELECT 'D:\extraction'||'extraction_'||'&NUMCLI'||'_'||to_char( sysdate , 'YYYYMMDD' )|| '.csv' l_file from dual;
Spool &l_file
--ici normalement ma requète
spool off
/ |
Partager