Function to convert fahrenheit to celsius
SQL> CREATE OR REPLACE FUNCTION fahrenheit_to_celsius (degree NUMBER) RETURN NUMBER IS 2 buffer NUMBER; 3 4 BEGIN 5 buffer := (5/9) * (degree - 32); 6 RETURN buffer; 7 END fahrenheit_to_celsius; 8 9 / Function created. SQL> SQL>