Oracle 动态Sql 变量绑定

 ls_sql_string := 'select  decode('''||V_DATA_TYPE||''',''B3'''||
                         ',STATISTICS_MONTH_VALUE,''B4'''||
                         ',STATISTICS_SEASON_VALUE,''B7'''||
                         ',STATISTICS_MYEAR_VALUE,''D3'''||
                         ',STATISTICS_MONTH_VALUE,''D4'''||
                         ',STATISTICS_SEASON_VALUE,''D7'''||
                         ',STATISTICS_MYEAR_VALUE,''B5'''||
                         ',STATISTICS_YEAR_VALUE,''D5'''||
                         ',STATISTICS_YEAR_VALUE,NULL)'||
                         'from V_STS_DMY_TARGET_VALUE_LIST where STATISTICS_CODE = :V_TARGET_CODE and STATISTICS_DATE = trunc(:V_DATE,''month'')';
                EXECUTE IMMEDIATE  ls_sql_string into  ln_return_value
                                  using  V_TARGET_CODE,V_DATE;