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.
Related Articles
 
								
							Oracle Multitenant Application Containers – Part XII Application...
As we learnt in my previous article in this series, with the introduction of Oracle multitenant application containers in Oracle Database 12.2.0.1, a user can create a common user in the CDB root or i...
 
								
							SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved...
This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the ini...
 
								
							How to Keep Certain Records on Top While Ordering Data? – Interview...
Question: How to Keep Certain Records on Top While Ordering Data? Let me elaborate this question as it is originally received. “Hi Pinal, I just returned from an interview and I faced a very strange ...
