oracle 直接执行sql 拼接sql Q‘[]‘ 避免‘‘ ‘‘

    v_sql varchar2(4000);
    v_count number;
begin
    v_sql := Q'[
        select count(*) 
        from ]' || para_temp_name || Q'[
        where year=:p_year and month=:p_month
    ]';
    EXECUTE IMMEDIATE v_sql INTO v_count USING para_year, para_month;