动态赋值问题

[st_snake_china]

select sum(to_number('d_fare'||xiaogaida_val.c_en_vehicle_class)) into agency_shao_money from fare

select sum('d_fare'||xiaogaida_val.c_en_vehicle_class) into agency_shao_money from fare

这两种写法都不对，帮我看看好吗？
想对d_fare1求和,但1是不确定的，为xiaogaida_val.c_en_vehicle_class的数值，有可能是d_fare2或d_fare3,xiaogaida_val.c_en_vehicle_class为字符型

[bzszp]

str varchar2(500);
begin
...
str:='select sum(d_fare' ¦ ¦xiaogaida_val.c_en_vehicle_class||') from fare';
execute immediate str into agency_shao_money;

[CodeMagic]

str varchar2(100);

str:='select sum(d_fare'||xiaogaida_val.c_en_vehicle_class||' from fare';
execute immediate str into agency_shao_money;

[CodeMagic]

str varchar2(100);

str:='select sum(d_fare'||xiaogaida_val.c_en_vehicle_class||' from fare';
execute immediate str into agency_shao_money;

[airpor]

还不如用decode写呢

select select sum(decode(xiaogaida_val.c_en_vehicle_class,'1',d_fare1,'2',d_fare2,d_fare1)) into agency_shao_money from fare

[dinya2003]

需要确定字段名的要动态sql来处理了. bzszp(www.bzszp.533.net) 的方法.

[WilliamXiaoLiang]

顶一下！
QQ:390958177
Email:[e-mail]