SQL> set serveroutput on
SQL> set echo on
SQL>
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> BEGIN
2 DBMS_OUTPUT.PUT_LINE('9 squared is ' || squareme(9) );
3 END;
4 /
9 squared is 81
PL/SQL procedure successfully completed.