oracle 步骤通过用户id查询金额

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;