|
SQL> -- The stored function squareme.
SQL> CREATE OR REPLACE FUNCTION squareme(thenum number)
2 RETURN NUMBER IS
3 BEGIN
4 RETURN thenum * thenum;
5 END squareme;
6 /
Function created.
SQL>
SQL>
SQL>
SQL> -- Passing parameters to squareme.
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE('9 squared is ' || squareme(9) );
3 END;
4
5 /
9 squared is 81
PL/SQL procedure successfully completed.
|