sqlplus tkcz1/tkcz145@topdb
SET NEWPAGE NONE
SET HEADING OFF
SET SPACE 0
SET PAGESIZE 0
SET TRIMOUT ON
SET TRIMSPOOL ON
SET LINESIZE 2500
spool 路徑+文件名
select * from tablename;
spool off
---員工資料sql語句
select cpf01||','||cpf02||','||cpf03||','||cpf14||','||cpf17||','||cpf24||','||gem_file.gem01||gem_file.gem02 ||','||cpf_file.cpf30||cpe_file.cpe02 from cpf_file
left join gem_file
on cpf_file.cpf29=gem_file.gem01
left join cpe_file
on cpe_file.cpe01=cpf_file.cpf30
---tkf刷卡資料
select tkf01||','||tkf02||','||tkf03||','||tkf04||','||tkf05||','||tkf06||','||tkf07||','||tkfacti||','||tkfuser||','||tkfgrup||','||tkfmodu||','||tkfdate||','||tkf08||','||tkf09||','||tkf10||','||tkf11 from tkf_file
where to_char(tkf02,'YYYYMM') between to_char(sysdate-60,'YYYYMM') and to_char(sysdate-30,'YYYYMM') ---近兩個月
order by tkf02 desc