借人气一问# Database - 数据库
d*r
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;
发信人: 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;
