Results 1 to 3 of 3

Thread: SQL - List custom functions

  1. #1
    Funking Prink! Raz316's Avatar
    Join Date
    Jul 2003
    Location
    Deal, Kent, UK
    Posts
    2,978
    Thanks
    130
    Thanked
    62 times in 52 posts

    SQL - List custom functions

    Is it possible to make sqlplus list all of the user created functions?

    Cheers

  2. #2
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,773
    Thanks
    22
    Thanked
    40 times in 24 posts
    I take it this isn't using SQL Server?
    Simon


  3. #3
    Funking Prink! Raz316's Avatar
    Join Date
    Jul 2003
    Location
    Deal, Kent, UK
    Posts
    2,978
    Thanks
    130
    Thanked
    62 times in 52 posts
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. looking for a banned word list
    By scottyman in forum Software
    Replies: 20
    Last Post: 13-10-2007, 07:13 PM
  2. more VBA and SQL 'problems'...
    By streetster in forum Software
    Replies: 7
    Last Post: 07-01-2004, 10:45 PM
  3. Win a YEARS SUBSCRIPTION to Custom PC
    By Zak33 in forum PC Hardware and Components
    Replies: 15
    Last Post: 14-10-2003, 01:48 PM
  4. Win a YEARS SUBSCRIPTION to Custom PC
    By Zak33 in forum General Discussion
    Replies: 3
    Last Post: 09-10-2003, 10:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •