Search sql function

Question

I have sql function in oracle
create or replace testfunc function .....

Compile it successfully. When I check the all_procedures system table, it does not exist. select * from all_procedures, where process_name is of type '% testfunc%';

Not sure if I am looking at the correct system table

Answer 1

Unless you use double-quoted identifiers to provide case sensitivity (something you almost don't want to do), Oracle will always store the identifiers in uppercase in the data dictionary. Therefore you would like

SELECT * FROM all_procedures WHERE procedure_name = 'TESTFUNC' 

Answer 2

Log in as system or sys as sysdba and request:

 SELECT * FROM dba_objects WHERE object_name LIKE '%TESTFUNC%' AND object_type='FUNCTION'; 

or

Register as a user and request:

 SELECT * FROM all_objects WHERE object_name LIKE '%TESTFUNC%'