Function_Returning_number1
Using Dual Table : Oracle tenders many choices to access the stored functions. Here I chose to use PHP server side scripts to call a stored function, which converts Celsius to Fahrenheit values.

Create Table :

create or replace
FUNCTION centfer(i IN NUMBER)
RETURN NUMBER AS
v_num NUMBER;j NUMBER;
BEGIN
v_num :=((i * 9/5) + 32 );
j:= v_num;
RETURN j ;
END centfer;

 
Query Using Dual : select centfer(25.21) as CElFah from dual