Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to replace text in a package using a query?

3198080Jan 24 2017 — edited Jan 25 2017

Hi all,

I have a line of text which is in several packages which I have already written. I need to replace all the packages at once using a query. For the specified text, I'm querying the ALL_SOURCE view. Is there any other way to do it?

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2017
Added on Jan 24 2017
31 comments
6,553 views