Besides SQL Optimizer, is there a tool that will rewrite complicated code to make it more simple? (4241975)

Is there a tool in Toad, besides SQL Optimizer, that will rewrite difficult to understand and complicated code, so that it is more simple and easier to follow?

There is a tool, starting in Toad 12.1, called Refactor that will rewrite code to make it more simple and easier to understand.  You can find Refactor in the right click menu of the Editor. 

There are several different types of refactoring that can be done by Toad.  Here is the list of what Toad can do with Refactor.
*Comment or Uncomment Block
* Add or Remove Column Aliases
*Convert ANSI or Oracle Join Syntax
*Remove Subqueries Using ANSI or Oracle Join Syntax
*Correct Where Clause Indentation Level
*Convert Decode Function to Case Statement
*Extract Procedure
*Find Unused Variables
*DBMS_PARALLEL_EXECUTE Wizard
*Rename Identifier
*Sync Order By with Group By

To use Refractor…

1. Put the code you want to be rewritten in an Editor.
2. Right click in the Editor and select Refactor and then which ever type of refractoring you want done.

Here is a video, which shows the new features in Toad for Oracle 12.0 and 12.1, that contains a demostration of Refactor.  You can find it at about the 7:47 mark of the video.