--610007570320-610007571319 1000张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007570320
and TO_NUMBER(bill_code) <= 610007571319); delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007570320
and TO_NUMBER(bill_code) <= 610007571319);
-- 610007572320-610007573319 1000张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007572320
and TO_NUMBER(bill_code) <= 610007573319);
--610007571320-610007572319 1000张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007571320
and TO_NUMBER(bill_code) <= 610007572319);
--610007585320-610007586319 1000张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007585320
and TO_NUMBER(bill_code) <= 610007586319);
-- 610007582320-610007583319 1000张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007582320
and TO_NUMBER(bill_code) <= 610007583319);
--610007575320-610007576319 1000张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007575320
and TO_NUMBER(bill_code) <= 610007576319);
-- 610007568320-610007569319 1000张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007568320
and TO_NUMBER(bill_code) <= 610007569319);
--610007578320-610007579319 1000张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007578320
and TO_NUMBER(bill_code) <= 610007579319);
--610007586320-610007587319 1000张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007586320
and TO_NUMBER(bill_code) <= 610007587319);
--610007550320-610007551319 1000张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007550320
and TO_NUMBER(bill_code) <= 610007551319);
--610007558940-610007559319 380张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007558940
and TO_NUMBER(bill_code) <= 610007559319);
--610007556320-610007557319 1000张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007556320
and TO_NUMBER(bill_code) <= 610007557319);
--610007589320-610007590319 1000张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007589320
and TO_NUMBER(bill_code) <= 610007590319);
--610007564320-610007565319 1000张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007564320
and TO_NUMBER(bill_code) <= 610007565319);
--610007581320-610007582319 1000张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007581320
and TO_NUMBER(bill_code) <= 610007582319);
--610007569320-610007570319 1000张 delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007569320
and TO_NUMBER(bill_code) <= 610007570319); --610007552320-610007553319 1000张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007552320
and TO_NUMBER(bill_code) <= 610007553319);
--610007558460-610007558819 360张
delete from (select t.*
from (select t1.bill_code, t1.bind_code, t1.use_flag
from t_mm_section_sl t1
where t1.bill_code like '6100075%') t
where TO_NUMBER(bill_code) >= 610007558460
and TO_NUMBER(bill_code) <= 610007558819);
commit;