函数内容如下所示,各位高人帮忙看下,本人刚接触oracle,有些地方不是很懂,希望大家多多指教。
create or replace function shdaini.function01
return varchar2 as
begin
declare sname varchar2(20);
begin
select re into sname from shdaini.usertable01 where id = 4;
return sname;
end;
end shdaini.function01;
/
create or replace function shdaini.function01
return varchar2 as
begin
declare sname varchar2(20);
begin
select re into sname from shdaini.usertable01 where id = 4;
return sname;
end;
end shdaini.function01;
/
/*函数的功能是将表中id=4的姓名取出来放入到sname中返回*/
create or replace function function01 return varchar2 as
--创建函数
begin
declare
sname varchar2(20); --声明变量
begin
select re into sname from usertable01 where id = 4;
return sname;
--返回name
end;
end function01;create table usertable01
(
id number(5),
re varchar2(200)
)insert into usertable01 values (4,'aaa');declareselect function01() from dual;楼主哪里不懂?
RETURN return_datatype
[AUTHID DEFINER | CURRENT_USER]
[DETERMINISTIC]
[PARALLEL ENABLE ...]
[PIPELINED]
IS
[declaration statements]
BEGIN
executable statements
[EXCEPTION
exception handler statements]
END [ name ];