Sometimes, you would want to generate a script that you would like to run repeatedly in many environments for many objects. In such situations, use of Database Export wizard helps you generate DDL and DML (INSERT) script; – you can select object types, specific objects and filter out or restrict the data exported. Step1: Source [...]
Archive of posts filed under the Development Tools category.
Customizing TOAD SQL Explain Plan Content
The default display of Explain Plan in TOAD SQL Editor has very basic information. Right-clicking on the explain plan and selecting “Adjust Content” from the context menu will bring “Execution Plan Preferences” window, which allows you to control the information displayed in the Explain Plan tab.