Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    44

    Unanswered: How to view the difinition of a procedure

    Hi All,

    Can someone know how to view the difinition of a procedure on SQLPlus?

    Thanks.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    select Text
    from DBA_SOURCE
    where Type = 'PROCEDURE'
    and Owner = UPPER('&&procedure_owner')
    and Name like UPPER('&&procedure_name')
    order by Owner, Name, Type, Line
    /


    hth
    Gregg

Posting Permissions

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