INFORMIX开发VSoracle开发
正在加载中...
资料简介:
informix指定到特定的partition上读取数据
v_sql:= ' insert into tmp_qh_voice_hlht_yyfx_rep3 '||
' select substr(t.start_datetime,1,6)'||
' from tl_y_voice_list_'||vi_month||' where day_id=v_day_id') '||
' where t.called_brand_code in (41,51,55,82,83,84,85,89) ';
execute immediate (v_sql);
informix是通过跳过片的方式来实现
....
v_sql:= ' insert into tmp_qh_voice_hlht_yyfx_rep3 '||
' select substr(t.start_datetime,1,6)'||
' from tl_y_voice_list_'||vi_month||' where day_id=v_day_id') '||
' where t.called_brand_code in (41,51,55,82,83,84,85,89) ';
execute immediate (v_sql);
informix是通过跳过片的方式来实现
....
2011-01-19
页数8
浏览1274
下载2