日期:2014-05-16  浏览次数:20401 次

oracle 方法通过用户id查询金额

create or replace function getCurrentTotalMoney(v_userId in integer) return integer is
  v_balance integer;
begin
  select t.totalmoney into v_balance from account t where t.userid = v_userId;
  dbms_output.put_line(v_balance);
  return(v_balance);
end getCurrentTotalMoney;
?