sp; when real_charge>=80000 and real_charge<90000 then 24000
when real_charge>=90000 and real_charge<100000 then 27000
when real_charge>=100000 and real_charge<110000 then 27000
when real_charge>=110000 and real_charge<120000 then 29000
when real_charge>=120000 then 36000
else
0
end ,acc_id,user_id,real_charge from okcai_jh_charge_200505在存储过程中
case v_strGroupClassCode
when ''''1'''' then
v_nAttrNum := v_nAttrNum + 300;
v_strAttrFlag := ''''1''''||substr(v_strAttrFlag,2,7);
when ''''2'''' then
v_nAttrNum := v_nAttrNum + 200;
v_strAttrFlag := ''''2''''||substr(v_strAttrFlag,2,7);
else
NULL;
end case;
注意的是存储过程和sql语句有的细微差别是用end case，而不是end。语句后面跟";"
上一页 [1] [2] [3] [4] |
