If you need remove code from a script, including PL/SQL, what you will do?
-
remove
-
comment the code
-
Either of them should be fine
-
Don't do anything
Commenting out code preserves it for reference while preventing execution, which is the standard practice for script maintenance. Deleting code permanently loses the logic, which cannot be recovered if needed later. This approach allows rollback without version control.
When you need to take code out of a script (including PL/SQL), the QA/DBA best-practice convention is to comment it out rather than physically delete it (id 601214). Commenting preserves the original logic for review, quick rollback, and audit history without executing it — important in deployment scripts where a hard delete loses context and makes reverting harder. Literal removal ('remove') destroys that safety net. The question is somewhat opinion-based and the wording is awkward, but under standard best-practice conventions for scripts, 'comment the code' is the expected answer, not the DB's 'remove'.