创建函数:
CREATE FUNCTION circle_area(
p_radius IN NUMBER
) RETURN NUMBER AS
v_pi NUMBER := 3.1415926;
v_area NUMBER;
BEGIN
v_area := v_pi * POWER(p_radius, 2);
RETURN v_area;
END circle_area;
/
调用存储过程:
SELECT circele_area(2)
FROM dual;
SELECT circele_area(p_radius => 4)
FROM dual;
获取函数信息
SELECT object_name, aggregate, parallel
FROM user_procedures
WHERE object_name IN ('CIRCLE_AREA');
删除函数:
DROP FUNCTION circle_area;