This content has been marked as final. Show 1 reply
If you have three pieces of code in any language that do similar things, you would want to refactor them, pulling out common elements into reusable components. It is no different with PL/SQL. Most of the effort in refactoring code goes into figuring out what those reusable components are and figuring out the appropriate interface for those components. Any reasonable IDE will provide you tools that automate the tedious bits of refactoring-- renaming variables, breaking a section of code out as a separate procedure, etc. But since 90% of the work is identifying what and how to refactor the code not in the mechanical task of implementing the actual refactoring, the benefit of using an IDE are not huge-- it's often just as easy to cut and paste in your favorite text editor.