To search and replace text in a program unit:
In the Object Navigator, expand the Program Units node.
Double-click
(the PL/SQL Editor view icon) next to the program unit you want to edit.
In the PL/SQL Editor, place your cursor where you wish to begin the search.
Choose EditFind and Replace.
In the dialog box, type your search criteria, and, optionally, the replace string. You can supply either a text string or a regular expression for your search text.
Click Search.
Upon locating an instance of the search criteria, click Replace to replace a single instance, Replace All to replace all instances, or edit the text directly in the PL/SQL Editor.
Click Search to proceed to the next instance, or click Cancel to close the dialog.
When you have finished replacing all text in the program unit, click Compile to recompile the program unit. Tip: If you replace text in multiple program units, you can recompile them all at once when you are finished.
When the code compiles successfully, click Close. Tip: If your edits are extensive, you may want to click Apply to save your changes incrementally, without having to compile.
Next step
Compiling a single program unit
Copyright © 1984, 2005, Oracle. All rights reserved.