1.不带参数的函数示例
create or replace function fun_hello
return varchar2
as
begin
return '广西外国语学院';
end;
调用
select fun_hello from dual;
begin
dbms_output.put_line(fun_hello);
end;
结果:
2.带参数的函数示例
create or replace function fun_emp(emp_no number)
return number
as
result number;
begin
select empno into result from emp where empno=emp_no;
return (result);
end;
调用:
select fun_emp(325) from dual;
结果: