Oracle 数列

----数列
select rownum as rn from dual connect by rownum<=5;
--连续求和
select rn, sum(a.rn) over(order by rownum) as srn
  from (select rownum as rn from dual connect by rownum <= 5) a;
--布尔运算
select s1,
       s2,
       s1 * s2 as bland,
       decode(s1 + s2, 0, 0, 1) blor,
       decode(s1 - s2, 0, 0, 1) as blxor
  from (select 0 as s1, 0 as s2
          from dual
        union all
        select 0 as s1, 1 as s2
          from dual
        union all
        select 1 as s1, 0 as s2
          from dual
        union all
        select 1 as s1, 1 as s2 from dual) a;