Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION totalFee
- (hours IN NUMBER, hourlyFee IN NUMBER, addFee IN BOOLEAN)
- RETURN NUMBER
- IS
- fee NUMBER;
- BEGIN
- case when addFee then fee := 100; else fee := 0; end case;
- return (hours*hourlyFee)+fee;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement