A stored function is a function with a specified name and stored into the current database. If you want to create a stored function, you can use the CREATE FUNCTION statement. The example script below creates a stored procedure:

SQL> CREATE OR REPLACE FUNCTION GET_SITE

2 RETURN VARCHAR2 AS

3 BEGIN

4 RETURN 'globalguidelinee.com';

5 END;

6 /

Function created.