declare
cursor c1 is
with
a as(
select rownum rn1,a from t3),
b as(
select rownum rn2,b from t3),
c as(
select rownum rn3,c from t3),
d as(
select rownum rn4,d from t3),
e as(
select rownum rn5,e from t3),
f as(
select rownum rn6,f from t3),
g as(
select rownum rn7,g from t3)
select * from a,b,c,d,e,f,g;
x int;
begin
for i in c1 loop
select count(m) into x
from (
select i.rn1 m from dual
union
select i.rn2 from dual
union
select i.rn3 from dual
union
select i.rn4 from dual
union
select i.rn5 from dual
union
select i.rn6 from dual
union
select i.rn7 from dual
);
if
x/7>0.5 then
insert into t4 values(i.a,i.b,i.c,i.d,i.e,i.f,i.g);
commit;
end if;
end loop;
end;
/
就是这个游标 怎么在mysql中试线这个游标的功能
试着调了半天 rownum这个不知道怎么解决 大哥大嫂来看下怎么弄吧
这个是表t3的表结构 t4 跟它是一样的
