适用于oracle10.0版本的melinets oracle sybase jdbc driver sqliteclientsyncprovider filename: 2014－06－25.doc date：june 25, 2014create table manager.tijiu(rec_ctrl_id char(10) not null,book_barcode varchar(24) not null);insert manager.tijiu
适用于 oracle 10.0版本的 melinets
  oracle sybase jdbc driver sqliteclientsyncprovider filename: 2014－06－25.doc date：june 25, 2014create table manager.tijiu(rec_ctrl_id char(10) not null,book_barcode varchar(24) not null);insert manager.tijiu(rec_ctrl_id,book_barcode)select rec_ctrl_id,book_barcode from manager.ct_1_a where department_id='32' and circul_num=0;//results rows 41815delete from manager.tijiu where rec_ctrl_id in (select rec_ctrl_id from circul.circulog_a where operate_date>='2008-01-01');//results rows 36753 delete from manager.tijiu where rec_ctrl_id in (select rec_ctrl_id from circul.circulog_archive_a where operate_date>='2008-01-01'); //results rows 31368delete from manager.tijiu where rec_ctrl_id in (select rec_ctrl_id from manager.ct_2_a where department_id='32' and date_in>='2010-01-01');//results rows 23694select a.title,b.book_barcode,a.class_no_1,c.book_search_no from manager.main_bibli a, manager.tijiu b, manager.ct_2_a cwhere a.rec_ctrl_id in(select rec_ctrl_id from manager.tijiu where b.rec_ctrl_id in(select rec_ctrl_id from manager.ct_2_a where b.rec_ctrl_id=c.rec_ctrl_id));//results rows 23694 in filename 剔旧20140625.txt