d******r
发帖数: 16947 | 1 【 以下文字转载自 JobHunting 讨论区 】
发信人: dinassor (人头马), 信区: JobHunting
标 题: 借人气一问
发信站: BBS 未名空间站 (Sun Dec 17 23:01:07 2006), 转信
for ft in (select ship_zip, dest_zip, dest_st, scac, weight from carrier_
trans_costs)
loop
begin
execute immediate v_select_sql into n_discount, n_minimum using ft
.scac, ft.ship_zip, ft.dest_st;
n_cost :=greatest(n_minimum, (1-n_discount)*get_cost(ft.ship_zip,
ft.dest_zip, ft.weight));
execute immediate v_update_sql using n_cost;
| I******e
发帖数: 101 | 2 What is you v_select_sql/v_update_sql?
ft
【在 d******r 的大作中提到】
: 【 以下文字转载自 JobHunting 讨论区 】
: 发信人: dinassor (人头马), 信区: JobHunting
: 标 题: 借人气一问
: 发信站: BBS 未名空间站 (Sun Dec 17 23:01:07 2006), 转信
: for ft in (select ship_zip, dest_zip, dest_st, scac, weight from carrier_
: trans_costs)
: loop
: begin
: execute immediate v_select_sql into n_discount, n_minimum using ft
: .scac, ft.ship_zip, ft.dest_st;
|
|
