Is it possible to make sqlplus list all of the user created functions?
Cheers![]()
Is it possible to make sqlplus list all of the user created functions?
Cheers![]()
Tis Oracle SQL
edit> think we have found it...
select Name, Owner, type from sys.dba_dependencies where type = 'FUNCTION' and owner = 'ORACLE'
seems a bit long winded but ah well, it works
thanks
Last edited by Raz316; 06-08-2004 at 11:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)