Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    2

    Exclamation Unanswered: Listing all procedures/functions

    Hi,

    Does anyone know how to list all the functions and procedures for a user in ORACLE?

    Can you please help me!!

    fennis

  2. #2
    Join Date
    Jan 2002
    Location
    west haven
    Posts
    33
    Do a select on dba_objects and use the where clause for object_type in ('FUNCTION', PROCEDURE') and owner = ownername;

Posting Permissions

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