--1.创建测试表
create table test (dtime date);
--2.循环插入测试数据
begin
for i in 1..50000 loop
insert into test
select *
from (select rownum rn,
to_date('2017-09-01', 'yyyy-mm-dd hh:mi:ss')+ rownum/24 dtime
from dual
connect by rownum<25
) a
where a.rn =(select round(dbms_random.value(1,24)) from dual);
end loop;
commit;
end;
--3.查询结果
select to_char(dtime,'hh24') hour,count(*) as cnt
from test
group by to_char(dtime,'hh24')
create table test (dtime date);
--2.循环插入测试数据
begin
for i in 1..50000 loop
insert into test
select *
from (select rownum rn,
to_date('2017-09-01', 'yyyy-mm-dd hh:mi:ss')+ rownum/24 dtime
from dual
connect by rownum<25
) a
where a.rn =(select round(dbms_random.value(1,24)) from dual);
end loop;
commit;
end;
--3.查询结果
select to_char(dtime,'hh24') hour,count(*) as cnt
from test
group by to_char(dtime,'hh24')
order by to_char(dtime,'hh24');