一.建立函数和数据表
二.调用方法
CREATE OR REPLACE FUNCTION getXM(INT1 NUMBER)
Return Varchar2
IS
ret Varchar2(36);
BEGIN
ret := '';
BEGIN
SELECT XM Into ret From GRADUATE Where YINGYU = INT1;
END;
RETURN (ret);
END;
create table GRADUATE
(
BH NUMBER(10) not null,
XM VARCHAR2(10) not null,
LB VARCHAR2(10) not null,
YINGYU NUMBER(4,1) not null,
ZHENGZHI NUMBER(4,1) not null,
ZHUANYE1 NUMBER(4,1) not null,
ZHUANYE2 NUMBER(4,1) not null,
ZHUANYE3 NUMBER(4,1) not null
)
二.调用方法
Select getXM(55),xm From graduate