oracle 函数操作

创建函数：

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;