A procedure can be compared to either an earlier version, or to the currently running code as compiled/stored in the database. The menu option Tools > Compare to Compiled Source enables the comparison of the procedure being edited with the code currently compiled and running in the database. If a viewer window is open (see the procedure editing section) then the Tools > Compare to Viewer menu option compares the contents of the viewer window with the current code. Therefore, to compare against an older version, we first load the viewer window with the older version and perform a Compare to Viewer.
The comparison highlight the differences, as shown in the example below:
In this example, the lines select @v_step = 0 and set @v_step = 10 have been removed from the current code in the edit window.
Once the comparison has been completed, you can either remove the compare comments or accept the compare changes. The menu option Tools > Remove Compare Comments removes the added blue comments and code. The menu option Tools > Accept Compare Changes implements the changes highlighted. For the above example the line select @v_step = 0 and set @v_step = 10 would be added.