Search for sql function
I have a sql function in oracle
create or replace function testfunc.....Compile it succesfully. When i verify all_procedures system开发者_高级运维 table it's not there. select * from all_procedures where procedure_name like '%testfunc%';
Not sure whether i am looking at the correct system table
Unless you are using double-quoted identifiers to enforce case-sensitivity (something you almost certainly don't want to do), Oracle will always store identifiers in upper case in the data dictionary. So you would want
SELECT *
FROM all_procedures
WHERE procedure_name = 'TESTFUNC'
Log in as system or sys as sysdba and query:
SELECT *
FROM dba_objects
WHERE object_name LIKE '%TESTFUNC%'
AND object_type='FUNCTION';
or
Log in as your user and query:
SELECT *
FROM all_objects
WHERE object_name LIKE '%TESTFUNC%'
精彩评论