Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Text of stored procedures

Text of stored procedures

From: Jeffrey C. Dege <jdege_at_jdege.visi.com>
Date: Tue, 12 Oct 1999 14:07:45 GMT
Message-Id: <slrn806gi2.717.jdege@jdege.visi.com>


How do I get the text of all the stored procedures in an Oracle database? I know they are in a system table somewhere, and I can view them one at a time in one of the enterprise manager tools, but I'd really like to grab them all to a text file, so I can search them all for 2-digit years in date formats, etc. (Rather than loading them one-by-one.)

--
First twenty-one new features that somehow we must add in.

    Then thirty-seven changes show up much to our chagrin. And this thing's just inadequate, and that one's just plain wrong.

    And by the way your schedule is about three months too long. Received on Tue Oct 12 1999 - 09:07:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US