In Oracle, is there a query to find whether a function exists?

Question

Suppose that I want to find out whether a function called PERIOD_DIFF exists in Oracle SQL.

Is there a way to do so via SQL*Plus , running a query ?

Answer 1

You can try one of these. user_source dba_source all_source

For example if you have access to dba_source, you can try something like this

 SELECT name from dba_source where type = 'FUNCTION' AND name LIKE '%PERIOD_DIFF%'/