Editions
TOAD is offered in five editions:
- Base
- Professional
- Xpert
- Developer
- DBA
There is also the module(?) Sensitive Data Protection which apparently requires a separate license.
Base
| utPLSQL unit testing | Incorporates testing into the database development process. |
| SQL editor | |
| Query builder | |
| Schema/data compare | referred as sync in Xpert and DB Admin module? |
| Task Automation | |
| Debugger/profiler | |
Pro
All of Base plus:
| Data generation | To generate test data |
| Code quality analysis and reporting | |
Xpert
All of Pro plus:
Xpert includes properietary SQL and index-optimization technology.
Developer
All of Xpert plus:
| Advanced PL/SQL unit testing | Code Tester? |
| Performance/benchmark testing | Benchmark Factory? |
The Developer edition complements the Toad DevOpts Toolkit solution.
DBA
All of Developer plus:
| Data Modeler | Create and maintain data models and reverse engineer data structures (from 20 different database platforms) |
| DB Admin Module | Database health, includes many other advanced functions. |
| Spotlight on Oracle | Performance and predicitve diagnostics |
TOAD Options
Enable Cancelling SQL Statements: View -> TOAD Options -> SQL Editor -> check Process statements in threads / allow queries to be cancelled.
Enable Timestamps: View -> TOAD Options -> Data Types -> check Include Timestamp/Interval Types (Orale 9i).
nls_date_format. Apparently TOAD (or its developers) choose to disregard the value of nls_date_format. It must be changed by View -> TOAD Options -> Data Grids -> Data -> Display -> Date format. (And even there, it's not possible to enter the format, it must be selected by drop down menues. WTF)