Take a closer look!
DUH! Check this out:
Code:
QL> CREATE OR REPLACE FUNCTION STATUS_DESC_SF
2 (stage_id IN NUMBER)
3 RETURN NUMBER
4 IS
5 stat_desc VARCHAR2(50);
6 BEGIN
7 CASE WHEN stage_id = 1 THEN
8 stat_desc:= 'Order Submitted';
9 WHEN stage_id = 2 THEN
10 stat_desc := 'Accepted, sent to shipping';
11 WHEN stage_id = 3 THEN
12 stat_desc := 'Backordered';
13 WHEN stage_id = 4 THEN
14 stat_desc := 'Cancelled';
15 ELSE stat_desc := 'Shipped';
16 END CASE;
17 RETURN stat_desc;
18 END;
19 /
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb