Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Text of stored procedures
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
![]() |
![]() |