DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Viewing the code in dbms_jobs

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Viewing the code in dbms_jobs

    Hi,

    I have a procedure u in dbms_jobs. How do I actually view the code other than using tools such as DBA studio or Quest?

    Thanks,
    Chucks

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    select text from user_source where name='PROCEDURE_NAME'

    HTH

    Srini

Posting Permissions

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


Click Here to Expand Forum to Full Width