Return number from a function : Function Return « Function Procedure Packages « Oracle PL/SQL Tutorial

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.

27.3.Function Return
	27.3.1.	Return Types
	27.3.2.	Returning values with functions
	27.3.3.	Return number from a function
	27.3.4.	Return value from a function
	27.3.5.	Multiple RETURN Statements
	27.3.6.	Returning a list based on parameters
	27.3.7.	Return date value from a function
	27.3.8.	A pipelined Table Function that returns a PL/SQL type
	27.3.9.	Return column type
	27.3.10.	Statements after Return will not be executed
	27.3.11.	create a function to return a employee record. accept employee numner return all fields.
	27.3.12.	Return a table collection
	27.3.13.	Demonstrate returning a record.
	27.3.14.	Return cursor from function
	27.3.15.	Return user-defined type