2) SQL cursors are bad and the syntax is fucking gross
3) Challenge problem assigned
4) I solve the problem:
- Code: Select all
CREATE OR REPLACE FUNCTION total_pounds_ordered_sf
(
lv_idbasket bb_basketitem.idbasket%TYPE
)
RETURN NUMBER
IS
lv_pounds_ordered NUMBER(36,2);
BEGIN
SELECT SUM(lbs)
INTO lv_pounds_ordered
FROM (
SELECT CASE
WHEN OPTION1 = 1 THEN QUANTITY * 0.5
WHEN OPTION1 = 2 THEN QUANTITY
ELSE 0 END AS lbs
FROM bb_basketitem
WHERE idbasket = lv_idbasket
);
RETURN lv_pounds_ordered;
END;
5) Teacher says no but we didn't use CASE statements recently...use cursors.
tl;dr this is the worst teacher I've ever had.