.in里的内容怎么动态.

  v_start_date             date;  v_end_date               date;  grantstr                 varchar2(500);  mgrantstr                varchar2(500);  begin      v_start_date := iv_start_date;      v_end_date   := iv_end_date + 1;      grantstr     := igrantstr;      mgrantstr:=replace(grantstr,',',''',''');      mgrantstr:=''''||mgrantstr||'''';      open ov_total for      select dvn.station_name,dvn.domain_value_name,count(station_id)           from (select ins.station_name,vli.vehicle_tag_no,vli.station_id,               dvi.domain_value_name,vli.grant_date               from vehicle_label_info vli,              (select * from domain_value_info where code_domain = 'LABEL') dvi,              (select * from INSPECTION_STATION) ins              where vli.label_type = dvi.id_domain_value(+)               and ins.station_id = vli.station_id(+)              and vli.station_id in (mgrantstr)              and vli.grant_date >= v_start_date               and vli.grant_date < v_end_date) dvn               group by dvn.station_name, dvn.domain_value_name              order by dvn.station_name;    end 

      open ov_total for      'select dvn.station_name,dvn.domain_value_name,count(station_id)           from (select ins.station_name,vli.vehicle_tag_no,vli.station_id,               dvi.domain_value_name,vli.grant_date               from vehicle_label_info vli,              (select * from domain_value_info where code_domain = ''LABEL'') dvi,              (select * from INSPECTION_STATION) ins              where vli.label_type = dvi.id_domain_value(+)               and ins.station_id = vli.station_id(+)              and vli.station_id in ('||mgrantstr||')              and vli.grant_date >= v_start_date               and vli.grant_date < v_end_date) dvn               group by dvn.station_name, dvn.domain_value_name              order by dvn.station_name';
------解决方案--------------------
楼上正解,open for 打开游标本身支持动态拼接语句