Toad offers cool feature called make/strip code. It allows you to copy code from, say, C# or Java into Toad, turn it into simple SQL, optimize it, then send it back to the original format for inclusion in the programming language. In fact, we eat our own dog food here: We code in Delphi, load all our SQL embedded in Delphi into Toad to optimize it, then put it back into the Delphi code.
Toad for Oracle – Will this optimization work with SQL statements embedded in a programming language?
