例子1：
-- 输入姓名，返回年薪
CREATE OR REPLACE FUNCTION JL_FUNC1(JLNAME VARCHAR2) RETURN NUMBER IS
YEARSAL NUMBER(7, 2);
BEGIN
SELECT SAL * 12 + NVL(COMM, 0) * 12
INTO YEARSAL
FROM EMP
WHERE ENAME = JLNAME;
RETURN YEARSAL;
END;
--函数的调用
var yearSal number;
call jl_func1('jlwang') into:yearSal;
-- 输入姓名，返回年薪
CREATE OR REPLACE FUNCTION JL_FUNC1(JLNAME VARCHAR2) RETURN NUMBER IS
YEARSAL NUMBER(7, 2);
BEGIN
SELECT SAL * 12 + NVL(COMM, 0) * 12
INTO YEARSAL
FROM EMP
WHERE ENAME = JLNAME;
RETURN YEARSAL;
END;
--函数的调用
var yearSal number;
call jl_func1('jlwang') into:yearSal;
453
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
