oracle function的根本语句

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;