17,382
社区成员




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
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 变量;
---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 bianliang
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 '||变量名;