Advertisement
Guest User

GUILHERME XXX

a guest
Nov 27th, 2014
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. Delimiter //
  2.  
  3. DROP FUNCTION IF EXISTS account_count //
  4.  
  5. create function account_count( c_name varchar (255))
  6.  
  7. returns integer
  8.  
  9. begin
  10. declare saldo integer;
  11.  
  12. select SUM(balance) into saldo
  13. from depositor NATURAL JOIN account
  14. where customer_name = c_name;
  15.  
  16. return saldo;
  17.  
  18. End //
  19.  
  20. Delimiter ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement