执行的表是动态的表,需要拼接字符串,然后查询出来的结果需要放在一个变量里,请问如何解决,谢谢!v_str_sql := ' select sum(sale_money)
FROM wcardoptLog where opt_code=''0'' and to_char(total_date) between substr('||in_begin_time||' , 1, 8) and
substr('||in_end_time||', 1, 8)';
EXECUTE IMMEDIATE v_str_sql
FROM wcardoptLog where opt_code=''0'' and to_char(total_date) between substr('||in_begin_time||' , 1, 8) and
substr('||in_end_time||', 1, 8)';
EXECUTE IMMEDIATE v_str_sql
v_str_sql := ' select sum(sale_money)
FROM wcardoptLog where opt_code=''0'' and to_char(total_date) between substr('||in_begin_time||' , 1, 8) and
substr('||in_end_time||', 1, 8) into '||变量名;
FROM wcardoptLog where opt_code=''0'' and to_char(total_date) between substr('||in_begin_time||' , 1, 8) and
substr('||in_end_time||', 1, 8)';
EXECUTE IMMEDIATE v_str_sql into bianliang
---to_char(total_date) 什么格式类型的记录
---in_end_time 字符型的不v_str_sql := ' select sum(sale_money)
FROM wcardoptLog where opt_code=''0'' and to_char(total_date) between substr('||in_begin_time||' , 1, 8) and
substr('||in_end_time||', 1, 8)';
EXECUTE IMMEDIATE v_str_sql into 变量
v_str_sql := ' select sum(sale_money)
FROM wcardoptLog where opt_code=''0'' and to_char(total_date) between substr('||in_begin_time||' , 1, 8) and
substr('||in_end_time||', 1, 8)';
EXECUTE IMMEDIATE v_str_sql into 变量;