SELECT COUNT(*) INTO COUNTER
FROM ALL_OBJECTS
WHERE OBJECT_TYPE='FUNCTION' AND OWNER=用户名 and object_name=函数名;当COUNTER=1,则符合该条件的函数存在。可以用select * from all_objects;来试试看结果
FROM ALL_OBJECTS
WHERE OBJECT_TYPE='FUNCTION' AND OWNER=用户名 and object_name=函数名;当COUNTER=1,则符合该条件的函数存在。可以用select * from all_objects;来试试看结果
all_objects是系统对象表
WHERE OBJECT_TYPE='FUNCTION' and object_name='函数名';