Question

Oracle怎么判断我的自定义函数存不存在

RT

Answer 1

SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE='FUNCTION'
查看自定义函数名的话，
用select OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE='FUNCTION';
或者select OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE='FUNCTION';
或者select OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE='FUNCTION';
函数的具体内容的话：select TEXT FROM USER_SOURCE WHERE NAME=函数名;select TEXT FROM ALL_SOURCE WHERE NAME=函数名;select TEXT FROM DBA_SOURCE WHERE NAME=函数名;

Answer 2

你用PL/sql development的funtion的文件中有没有你建的函数

Answer 3

select * from user_source where name='函数名';

Answer 4

在这个系统字典表 USER_OBJECTS 里找。