1.不带参数的
create or replace function getUser return varchar2 is
test varchar2(20);
begin
test := '123';
return test;
end;
执行: select getUser from dual;
2.带in参数的
create or replace function test(par in varchar2) return varchar2 is
v varchar2(20);
begin
v := par;
return v;
end;
执行: select test(‘hello’) from dual