Call user defined function in DBMS_OUTPUT.PUT_LINE : DBMS_OUTPUT « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. DBMS_OUTPUT

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.

SQL>
SQL>
SQL>