趣题, 第8道来了。

ccceleven

declare
  -- Local variables here
i_h number:=0;
i_m number;
i_xh number;
v_cnt number:=0;
v_h1 number;
v_h2 number;
begin
  while (i_h<=12) loop
    select mod(i_h,1)*60 into i_m from dual;
    select round(mod(i_m/5,1)*60/5,3) into i_xh from dual;
    select abs(i_xh-i_h) into v_h1 from dual;
    if v_h1<0.01 or i_h=12  then
    dbms_output.put_line(i_h||'|'||i_m/5);
      v_cnt:=v_cnt+1;
      end if;
    i_h:=i_h+0.001;
    end loop;
end;

精确度 0.1
有
0
.084
.168
.252
.335
.336
.419
.42
.503
.504
.587
.588
.671
.672
.755
.839
.923
1.007
1.091
1.175
1.259
1.342
1.343
1.426
1.427
1.51
1.511
1.594
1.595
1.678
1.679
1.762
1.846
1.93
2.014
2.098
2.182
2.266
2.349
2.35
2.433
2.434
2.517
2.518
2.601
2.602
2.685
2.686
2.769
2.853
2.937
3.021
3.105
3.189
3.273
3.356
3.357
3.44
3.441
3.524
3.525
3.608
3.609
3.692
3.693
3.776
3.86
3.944
4.028
4.112
4.196
4.28
4.363
4.364
4.447
4.448
4.531
4.532
4.615
4.616
4.699
4.783
4.867
4.951
5.035
5.119
5.203
5.287
5.37
5.371
5.454
5.455
5.538
5.539
5.622
5.623
5.706
5.79
5.874
5.958
6.042
6.126
6.21
6.294
6.377
6.378
6.461
6.462
6.545
6.546
6.629
6.63
6.713
6.797
6.881
6.965
7.049
7.133
7.217
7.301
7.384
7.385
7.468
7.469
7.552
7.553
7.636
7.637
7.72
7.804
7.888
7.972
8.056
8.14
8.224
8.307
8.308
8.391
8.392
8.475
8.476
8.559
8.56
8.643
8.644
8.727
8.811
8.895
8.979
9.063
9.147
9.231
9.314
9.315
9.398
9.399
9.482
9.483
9.566
9.567
9.65
9.651
9.734
9.818
9.902
9.986
10.07
10.154
10.238
10.321
10.322
10.405
10.406
10.489
10.49
10.573
10.574
10.657
10.658
10.741
10.825
10.909
10.993
11.077
11.161
11.245
11.328
11.329
11.412
11.413
11.496
11.497
11.58
11.581
11.664
11.665
11.748
11.832
11.916
12

精确度0.01有
0
1.007
2.014
2.937
3.021
3.944
4.028
4.951
5.035
5.958
6.042
6.965
7.049
7.972
8.056
8.979
9.063
9.986
10.993
12

花落无声_spj

ei0123

ei0123

SQL> with t as (select rownum,to_char(trunc(sysdate)+rownum/1440,'hh:mi') as time,mod(rownum*6,360) as mi,trunc(rownum/12)*6 as hh from dual connect by rownum<721)
  2       select a.time,a.hh,a.mi,b.time from t a,t b where a.mi=b.hh and a.hh=b.mi order by a.time;

TIME          HH         MI TIME
----- ---------- ---------- -----
01:00         30          0 12:05
01:05         30         30 01:05
01:10         30         60 02:05
01:15         36         90 03:06
01:20         36        120 04:06
01:25         42        150 05:07
01:30         42        180 06:07
01:35         42        210 07:07
01:40         48        240 08:08
01:45         48        270 09:08

三市白

mark BD