1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| set term off;
set heading off;
set pagesize 0;
set colsep '';
set space 0;
set trimout on;
set trimspool off;
set tab off;
set feedback off;
set linesize 6106;
spool monfichier.txt;
SELECT
rpad(s_evt_act_x.row_id,15),
nvl(to_char(s_evt_act_x.created,'yyyymmdd'),' '),
rpad(s_evt_act_x.created_by,15),
nvl(to_char(s_evt_act_x.last_upd,'yyyymmdd'),' '),
rpad(s_evt_act_x.last_upd_by,15),
rpad(s_evt_act_x.par_row_id,15),
rpad(s_evt_act_x.attrib_04,30),
rpad(s_evt_act_x.x_action_prise,2000),
rpad(s_evt_act_x.x_description,4000)
FROM
s_evt_act_x
ORDER BY
s_evt_act_x.row_id;
spool off; |
Partager