Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    67

    Unanswered: how to identify all stored procs containing a particular word

    Dear Gurus,
    Please let us know, How to identify the name of all SPs using a particular word

    Thanks in advance,
    Vrsrinivas

  2. #2
    Join Date
    Dec 2007
    Posts
    253
    You would do a wildcard search of the all_source data dictionary table. Do you know how to use wildacrds? (the % and the _ with the LIKE operator)

  3. #3
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    SELECT distinct name FROM dba_source
    WHERE name LIKE '%SOMETHING%';
    JoeB
    save disk space, use smaller fonts

  4. #4
    Join Date
    Dec 2007
    Posts
    253
    Speechless

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by joebednarz
    SELECT distinct name FROM dba_source
    WHERE name LIKE '%SOMETHING%';
    close, but no cigar.

    Code:
    select distinct name 
    from all_source
    where upper(TEXT) like '%SOMETHING%';
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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