Examples:

**Code:**create or replace function f_one return number
as
begin return 1.5;
end;

In an Excel cell, type the formula:

=sqlfunction("f_one")

Or execute the following SQL:

:D10 := f_one;

The same can be done for dates:

**Code:**create or replace function f_sysdate return date
as
begin return sysdate;
end;

In an Excel cell, type the formula:

=sqlfunction("f_sysdate")

Or execute the following SQL:

:D10 := f_sysdate;