Oracle PL/SQL Tutorial/PL SQL Programming/Decode
Use decode in PL/SQL
<source lang="sql">
SQL> SQL> SQL> CREATE OR REPLACE FUNCTION AverageGrade (p_Course IN NUMBER) RETURN VARCHAR2 AS
2 v_NumericGrade varchar(1); 3 BEGIN 4 SELECT DECODE(ROUND(p_Course), 5, "A", 5 4, "B", 6 3, "C", 7 2, "D", 8 1, "E") 9 INTO v_NumericGrade 10 FROM dual; 11 12 RETURN v_NumericGrade; 13 END AverageGrade; 14 /
Function created. SQL> SQL> SQL> select AverageGrade(1) from dual; AVERAGEGRADE(1)
E</source>