Login | Register
The get_customer_balance function returns the current amount owing on a specified customer's account.
get_customer_balance
p_customer_id: The ID of the customer to check, from the customer_id column of the customer table.
p_customer_id
customer_id
customer
p_effective_date: The cutoff date for items that will be applied to the balance. Any rentals, payments, and so forth after this date are not counted.
p_effective_date
This function returns the amount owing on the customer's account.
mysql> SELECT get_customer_balance(298,NOW()); +---------------------------------+ | get_customer_balance(298,NOW()) | +---------------------------------+ | 22.00 | +---------------------------------+ 1 row in set (0.00 sec)
SELECT get_customer_balance(298,NOW());
© 2013, Oracle Corporation and/or its affiliates
