SQL> create procedure xn_del_traffic3(
2 sttime in date,
3 edtime in date,
4 sttxt in char,
5 edtxt in char,
6 tracount out float)
7 as
8 begin
9 delete from wx_rp_traffic
10 where start_time between sttime and edtime
11 and to_char(start_time,'hh24:mi:ss') between sttxt and edtxt;
12 commit;
13 select count(*) into tracount from wx_rp_traffic;
14 end;
15 /
2 sttime in date,
3 edtime in date,
4 sttxt in char,
5 edtxt in char,
6 tracount out float)
7 as
8 begin
9 delete from wx_rp_traffic
10 where start_time between sttime and edtime
11 and to_char(start_time,'hh24:mi:ss') between sttxt and edtxt;
12 commit;
13 select count(*) into tracount from wx_rp_traffic;
14 end;
15 /
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货