 |
|
|
|
|
|
|
|
|
|
|
|
|
Check out our user-submitted tips and tricks!. Found an ingenious way to use a feature? Want to share it with other members? Well...now you can. Just submit your tips and tricks here. Our product management team will review and approve them.
|
Quickly Generate Schema Documentation with Toad
|
Submitted By: Ben Boise
Date: 05/05/2008 06:49
|
Generating Schema Documentation in Toad.
Find yourself spending too much time generating Schema documentation for your coworkers? Check out Toad's HTML Schema Doc Generator.
From the Database menu, select Report -> HTML Schema Doc Generator.
Documentation can be generated for one or more schemas and you can choose the amount of detail you wish to include in the report. You can even customize the look and feel of the report and add your company's logo to impress your boss along the way!
|
|
|
|
|
|
How to bookmark your favorite SQL?
|
Submitted By: Kuljit
Date: 04/25/2008 08:33
|
Ever need a quick way of retrieving your favorite sql statements without browsing for them?
When you are in the editor and you have your sql statement open, go up to the Edit Menu and select "Add to Named SQLs". This will prompt you to give your sql statement a name. If you want to add a statement to your favorites and you ran it a while ago and no longer have it open, just press "F8" to open your SQL Recall window and find it under the History tab. Once you locate the sql statement, right click on it and add it to your Named SQLs.
In the future now, when you open an editor use the hotkeys "Cntrl+N" and it will open a list of your Named SQLs you have saved. Click the one you want and it opens immediately into your editor.
This way you can quickly call sql statements you use most often without browsing for them or opening up a sql file that may contain them.
|
|
|
|
|
|
How can I shorten the list of Schemas in the Schema Browser and other windows?
|
Submitted By: DevinG
Date: 04/25/2008 08:32
|
Tired of navigating the long list of Schemas in the Schema Browser or Object Pallette?
When you connect to Oracle using Toad, you will see all of the schemas or users you have permissions to see. Many of these schemas are internal Oracle schemas and users you do not need to see. To edit this list, go to the Session menu, and choose Oracle Users List. Here you can check all the schemas you would like to display, and hide all the other schemas from the dropdown.
Devin Gallagher
Quest Software
|
|
|
|
|
|
Create Standard Code Templates for new hires
|
Submitted By: tjrockit
Date: 04/25/2008 08:31
|
In previous versions of Toad, the code templates were stored in file PLSQL.DCI. In Toad version 9.0, the code templates are now stored in file LexLib.LXL
Personally, the old version was much easier to edit and distribute to new hires.
|
|
|
|
|
|
Beware when Saving as Excel File
|
Submitted By: danwood
Date: 04/25/2008 08:29
|
It has been my experience that when saving a datagrid as an Excel file, once you get above a 1,000 or so rows, the conversion takes expotentially longer to complete. I have found that when saving large datagrids, it is far more efficient to Save As a Delimited Text file, which will auto-open in Excel in a far shorter time. It is easy from there to save the file as an Excel workbook. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|