Oracle FUNCTION
Check
Check
List all Functions...
SELECT owner,
object_name,
object_type
FROM dba_objects
WHERE object_type = 'FUNCTION';
ORDER BY owner,
object_name
Find a specific Function...
SELECT owner,
object_name,
object_type
FROM dba_objects
WHERE object_name = '&MYFUNCNAME';
Show FUNCTION DDL
Show FUNCTION DDL
You can extract the FUNCTION DDL using DBMS_METADATA...
SET LONG 100000
SELECT dbms_metadata.get_ddl('FUNCTION',UPPER('&MYFUNCNAME'),UPPER('&MYSCHEMA')) AS job_definition_ddl
FROM dual;
Bibliography
Bibliography