create or replace function functionname return datatype is returnvalue datetype; begin sql; returnvalue := xxx; exception when others then xxx end function结构基本是这样,sql和返回值自己写吧
看到sex这个词了,用gender更好 :),里面的内容用M(male), F(female) create a test table: create table test_role( ROIEID int, USERID int, user_NAME varchar2(20), gender varchar2(1))create a function: create or replace function add_role(p_roleid in int, p_userid in int, p_user_name in varchar2, p_gender in int) return int is begin insert into test_role (roieid, userid, user_name, gender) values (p_roleid, p_userid, p_user_name, p_gender); return 1; end;
return datatype
is
returnvalue datetype;
begin
sql;
returnvalue := xxx;
exception
when others then
xxx
end function结构基本是这样,sql和返回值自己写吧
create a test table:
create table test_role(
ROIEID int,
USERID int,
user_NAME varchar2(20),
gender varchar2(1))create a function:
create or replace function add_role(p_roleid in int,
p_userid in int,
p_user_name in varchar2,
p_gender in int) return int is
begin
insert into test_role
(roieid, userid, user_name, gender)
values
(p_roleid, p_userid, p_user_name, p_gender);
return 1;
end;