Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Delimiter //
- DROP FUNCTION IF EXISTS account_count //
- create function account_count( c_name varchar (255))
- returns integer
- begin
- declare saldo integer;
- select SUM(balance) into saldo
- from depositor NATURAL JOIN account
- where customer_name = c_name;
- return saldo;
- End //
- Delimiter ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement