核心提示:oracle function的基本语句CREATE OR REPLACE FUNCTION 'OMSFM'.'TEST1'(inParam in varchar2,outParam out numb...
oracle function的基本语句 CREATE OR REPLACE FUNCTION "OMSFM"."TEST1"(inParam in varchar2,outParam out number)
RETURN VARCHAR2
IS
avgSal number;
BEGIN
select avg(salary) into avgSal from test where name like inParam||'%';
outParam:=avgSal;
--if else 语句
IF avgSal=20 THEN
DBMS_OUTPUT.PUT_LINE('2Sample output outParam='|| avgSal);
ELSIF avgSal=30 THEN
DBMS_OUTPUT.PUT_LINE('3Sample output outParam='|| avgSal);
ELSIF avgSal=10 THEN
DBMS_OUTPUT.PUT_LINE('11Sample output outParam='|| avgSal);
END IF;
--do loop
RETURN (avgSal);
END;
Java免费学习 Java自学网 http://www.javalearns.com
关注微信号:javalearns 随时随地学Java
或扫一扫
随时随地学Java