CODEWITHSUNDEEP
sqloracle-databaseplsqloracle10g
Arav
Arav

Reputation: 5247

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

Upvotes: 4

Views: 977

Answers (2)

kupa
kupa

Reputation: 1890

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%'

Upvotes: 2

Justin Cave
Justin Cave

Reputation: 231671

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'

Upvotes: 13

Related Questions