好像只能插单行单列 可有插多行的呢?insert into t_result (F_TASK_NAME,F_CREATER_NAME,f_result); ('过程名',‘新建人张山’select result1||result2 from student)
c_resultset:='f_day '||' '||'f_num '||chr(10); for c in( SELECT to_char(f_regtime,'yyyy-mm-dd') as f_day, to_char(count(f_username)) as f_num FROM T_BASE_USERINFO X WHERE X.F_COMECHANNEL='500wan' AND X.F_REGTIME BETWEEN TO_DATE('2010-01-25','yyyy-mm-dd') AND TO_DATE('2010-02-01','yyyy-mm-dd') group by to_char(f_regtime,'yyyy-mm-dd') ) loop c_resultset:=c_resultset||c.f_day||' '||c.f_num||chr(10); end loop ; insert into T_QUERY_PROC_TASK_RESULT values ('P_TEST','shark',sysdate,c_resultset);
||f_result from dual;
http://school.itzcn.com/special-spid-35.html
上面讲解的比较详细,
希望对楼主有所帮助。
('过程名',‘新建人张山’select result1||result2 from student)
for c in(
SELECT to_char(f_regtime,'yyyy-mm-dd') as f_day, to_char(count(f_username)) as f_num
FROM T_BASE_USERINFO X
WHERE X.F_COMECHANNEL='500wan'
AND X.F_REGTIME BETWEEN TO_DATE('2010-01-25','yyyy-mm-dd') AND TO_DATE('2010-02-01','yyyy-mm-dd')
group by to_char(f_regtime,'yyyy-mm-dd')
)
loop
c_resultset:=c_resultset||c.f_day||' '||c.f_num||chr(10);
end loop ; insert into T_QUERY_PROC_TASK_RESULT values ('P_TEST','shark',sysdate,c_resultset);