Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Unanswered: how to display the full text of procedure or function?

    when i query as follows:

    select text from user_source where ......


    only one part of full contents is displayed.
    so i wonder how to display the full contents???


    thanks!!!

  2. #2
    Join Date
    Jul 2003
    Location
    Hong Kong
    Posts
    56

    Re: how to display the full text of procedure or function?

    The result should gives multiple records with different line numbers which combine together as the whole procedure.

    select text from user_source
    where name ='procedure_name' order by line;

    What's your sql statement anyway?
    Cheers,
    Shev

Posting Permissions

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