Advertisement
Guest User

Untitled

a guest
Nov 17th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION totalFee
  2. (hours IN NUMBER, hourlyFee IN NUMBER, addFee IN BOOLEAN)
  3. RETURN NUMBER
  4. IS
  5. fee NUMBER;
  6. BEGIN
  7. case when addFee then fee := 100; else fee := 0; end case;
  8. return (hours*hourlyFee)+fee;
  9. END;
  10. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement