Database Reference
In-Depth Information
FUNCTION fTOK(f VARCHAR2 DEFAULT 0) RETURN VARCHAR2;
FUNCTION KTOf(K VARCHAR2 DEFAULT 0) RETURN VARCHAR2;
FUNCTION cTOK(c VARCHAR2 DEFAULT 0) RETURN VARCHAR2;
FUNCTION KTOc(K VARCHAR2 DEFAULT 0) RETURN VARCHAR2;
END;
/
CREATE OR REPLACE PACKAGE BODY TEMPERATURE AS
FUNCTION cTOf(c VARCHAR2 DEFAULT 0) RETURN VARCHAR2 AS
BEGIN
RETURN TO_CHAR(c)||'C˚ = '||ROUND(32+((9/
5)*c),0)||'F˚';
END;
FUNCTION fTOc(f VARCHAR2 DEFAULT 0) RETURN VARCHAR2 AS
BEGIN
RETURN TO_CHAR(f)||'F˚ = '||ROUND((5/9)*(f-
32),0)||'C˚';
END;
FUNCTION fTOK(f VARCHAR2 DEFAULT 0) RETURN VARCHAR2 AS
BEGIN
RETURN TO_CHAR(f)||'F˚ = '||ROUND(32+((9/5)*f)-
273.15,0)||'K˚';
END;
FUNCTION KTOf(K VARCHAR2 DEFAULT 0) RETURN VARCHAR2 AS
BEGIN
RETURN TO_CHAR(K)||'K˚ = '||ROUND((5/9)*(K+273.15-
32))||'F˚';
END;
FUNCTION cTOK(c VARCHAR2 DEFAULT 0) RETURN VARCHAR2 AS
BEGIN
RETURN TO_CHAR(c)||'C˚ = '||ROUND(c-273.15,0)||'K˚';
END;
FUNCTION KTOc(K VARCHAR2 DEFAULT 0) RETURN VARCHAR2 AS
BEGIN
RETURN TO_CHAR(K)||'K˚ = '||ROUND(K+273.15,0)||'C˚';
END;
END;
/
Now let's look into variables and datatypes for PL/SQL.
