Oracle database programming

Posted on 2004-11-08
Last Modified: 2012-05-05
How can I view a storedprocedure in oracle?

We can view storedprocedure in SQL server as sp_helptext <ProcName>.

Is there is any option in Oracle something like this?

Plz help me.
Question by:e_senthil
    1 Comment
    LVL 2

    Accepted Solution

    There are two data dictionary tables, USER_SOURCE|DBA_SOURCE, which store the text of any stored procedure/function/package.

    IE. Issue the following command in SQL*Plus (after you connect to the instance)...
    SELECT text
       FROM user_source
     WHERE name = <ProcName>
    ORDER BY line


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
    This is an explanation of a simple data model to help parse a JSON feed
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now