SQL> -- The mypi function.
SQL> CREATE OR REPLACE FUNCTION mypi
2 RETURN NUMBER IS
3 BEGIN
4 NULL;
5 RETURN 3.14;
6 END mypi;
7 /
Function created.
SQL>
SQL> -- Verifying the mypi function.
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE('value of pi is ' || mypi());
3 END;
4 /
value of pi is 3.14
PL/SQL procedure successfully completed.
SQL>