declare var_sql varchar2(8000); --存放构造游标的sql语句 type mycursor is ref cursor; --定义游标类型 mycur mycursor; --定义动态游标 begin var_sql := 'select a, sum(b),sum(c) from '||Tablename||sysdate||' where d = e group by a'; open mycur for var_sql; --打开游标 ... --执行代码 close mycur; end;
不好意思,我的语句里面的e也是动态的,应该是where d = :e
把 select a, sum(b),sum(c) from Tablename||sysdate where d = e group by a; 设置为字符串, 然后exec sql就像adaizi1980(阿代) 所言。
可以有fetchdeclare var_sql varchar2(8000); --存放构造游标的sql语句 type mycursor is ref cursor; --定义游标类型 mycur mycursor; --定义动态游标 begin var_sql := 'select a, sum(b),sum(c) from '||Tablename||sysdate||' where d = e group by a'; open mycur for var_sql; --打开游标 ... --执行代码 close mycur; end;
var_sql varchar2(8000); --存放构造游标的sql语句
type mycursor is ref cursor; --定义游标类型
mycur mycursor; --定义动态游标
begin
var_sql := 'select a, sum(b),sum(c) from '||Tablename||sysdate||' where d = e
group by a';
open mycur for var_sql; --打开游标
... --执行代码
close mycur;
end;
group by a;
设置为字符串,
然后exec sql就像adaizi1980(阿代) 所言。
var_sql varchar2(8000); --存放构造游标的sql语句
type mycursor is ref cursor; --定义游标类型
mycur mycursor; --定义动态游标
begin
var_sql := 'select a, sum(b),sum(c) from '||Tablename||sysdate||' where d = e
group by a';
open mycur for var_sql; --打开游标
... --执行代码
close mycur;
end;