WIXLIB

Toad for Oracle Editions 2020 R2 Functional MatrixEssential FunctionalityToad for OracleBaseSubscriptionToad for OracleProfessionalEditionToad for OracleXpert EditionToad DB AdminModule(add-on)Toad for OracleDeveloperEditionToad for OracleDBA EditionToad for OracleDBARAC/ExadataEditionSingle user subscription billing (12-month term) MDI and SDI window mode to support twin monitors Browse and navigate through objects Create and manipulate database objects throughgraphical interfaces Edit: snippets, predictive typing, syntaxhighlighting, code folding, spell check Customize code templates and code formatter Save, nickname & share previously executed SQL Query Builder Integrated Debugger (DBMS, JDWP and Script) Automated DBMS OUTPUT.PUT LINE debugging Advanced ER Diagram with HTML reports and e-mail Unicode and Multibyte Character Set support Development FunctionalityBuild database PL/SQL code dependencies diagram(Code Road Map)Compare code difference in database objectsand filesExternal/remote debugging (used when the DBcode is called from apps. like Java, C , VB, etc.)Export Oracle APEX applicationsConvert embedded SQL to other programminglanguages (Delphi, C, C , Java, Perl and VB etc.)Quest Software Inc Updated January 2021

Toad for Oracle Editions 2020 R2 Functional MatrixToad for OracleDBARAC/ExadataEditionToad for OracleBaseSubscriptionToad for OracleProfessionalEditionToad for OracleXpert EditionView multiple results sets from executed SQL scripts Publish Java classes to PL/SQL Store PL/SQL execution parameters for re-use Browse Oracle Export Utility file contentand selectively extract objects and data Essential PL/SQL unit test creation andexecution based on utPLSQL framework Development FunctionalityAdvanced PL/SQL unit test creation (inc samplelibrary) and execution. Tests stored in repository forfuture regression testing or as part of a DevOps buildautomation process using Toad DevOps Toolkit.Automatically identify unit tests out of synch withcorresponding database source objectsToad DB AdminModule(add-on)Toad for OracleDeveloperEditionToad forOracle DBAEdition Team CollaborationShare common standards and templates Integrates with multiple version controlsystem providers (inc Git, SVN, TFS &Mercurial) Perform automated code review quality validationprior to version control check-inManage project assetsImport and Export Code Quality Rules and Rules Setsfor team sharingAccess to Toad World user forums inside Toad foradvice, problem resolution and knowledge transferAccess to free web-based Toad Training classes onToad World launchable from inside ToadQuest Software Inc Updated January 2021

Toad for Oracle Editions 2020 R2 Functional MatrixToad for OracleDBARAC/ExadataEditionCode Quality Analysis and SQL TuningToad for OracleBaseSubscriptionToad for OracleProfessionalEditionToad for OracleXpert EditionPL/SQL profiling to detect code performancebottlenecks Configurable visual SQL explain plan Trace user sessions and visually display OracleTrace file outputDisplay user session info & performance metricsToad DB AdminModule(add-on)Toad for OracleDeveloperEdition Toad forOracle DBAEdition Automate code analysis and validation againstSQL and PL/SQL coding best practices Automated, customizable, objective code review &analysis with reports, maximizing code quality Recommend indexing changes based oncontinuous database workload assessment Analyze impact of changes to database environmentthrough index simulation Identify coding best practice violationsdynamically during editingIdentify problematic SQL directly from databaseobjects, files and source codeAutomate creation of SQL rewrites to find mostefficient SQL alternative (internal to Editor or viaexternal advanced SQL Optimizer)Optimize multiple SQL statements in batch incontext with the source codeOracle SQL tuning suggestions via the OracleTuning Advisor (via Tuning & Diagnostics Packs)* SQL and PL/SQL production scalability testingTrack real-time SQL executions from clientapplications to help locate issues or perform QAQuest Software Inc Updated January 2021

Toad for Oracle Editions 2020 R2 Functional MatrixDatabase, Schema and Data ChangeManagementAdvanced, highly productive data grids offeringsimple column selectivity and groupingMonitor and report on the use of PersonallyIdentifiable Information (Sensitive Data Awareness)in the Editor for GDPR complianceImport/export data from data grid into/fromExcel files and other formatsToad for OracleDBARAC/ExadataEdition Toad for OracleProfessionalEditionToad for OracleXpert Edition Compare and synch data across multiple tablesDisplay table data representing Parent-Childdependencies (Master Detail Browser)Toad forOracle DBAEditionToad for OracleBaseSubscription Toad DBToad for OracleAdmin ModuleDeveloper Edition(add-on)Replay captured database workloads in a testdatabase to simulate production activityCompare schemas using live connectionsCompare schemas from a fixed baseline using offlineToad snapshot files Compare and generate Multi Schema change scriptsbetween two database environmentsGenerate test data (randomized or real-world) withdata masking. Access Oracle Import/Export utilities Oracle Spatial datatype support Analyze the performance impact of new indexes,index changes and parameter changes on SQL Analyze the performance impact of moving SQLstatements from one database to another Analyze SQL execution plan changes betweendatabase environments (i.e. dev. vs. prod. or Oracle12c vs 19c) Quest Software IncUpdated January 2021

Toad for Oracle Editions 2020 R2 Functional MatrixToad forOracle DBAEditionToad for OracleDBARAC/ExadataEditionReverse engineer object DDL including roles &permissions into a physical data model (via ToadData Modeler - TDM) Reverse engineer database schema into aphysical data model, compare with anotherversion and generate alter scripts (TDM) Database, Schema and Data ChangeManagementToad for OracleBaseSubscriptionToad for OracleProfessionalEditionToad for OracleXpert EditionToad DBToad for OracleAdmin ModuleDeveloper Edition(add-on)Reverse engineer physical data model into aplatform agnostic conceptual data model (TDM)Round-trip engineer from database or DDLbetween different database platforms such asOracle, SQL Server, SAP Sybase, DB2, etc. (TDM)Compare and generate schema change scriptsbetween two or more schema versions Compare and generate schema change scriptsbetween two or more versions of Toad schemasnapshot files Compare and generate database configurationchange scripts between two or more databases Compare and generate database configurationchange scripts between two or more versions ofToad database snapshot files Toad for Oracle Toad DB Admin Toad for OracleDeveloperXpert Edition Module (add-on)EditionToad forOracle DBAEditionToad for OracleDBARAC/ExadataEditionToad for OracleBaseSubscriptionToad for OracleProfessionalEditionGenerate customizable schema and databasereports in HTML format Automate report generation and distribution ReportingQuest Software IncUpdated January 2021

Toad for Oracle Editions 2020 R2 Functional MatrixReportingToad for OracleBaseSubscriptionGenerate code review reports covering allaspects of code quality assessmentGenerate reports on over 200 aspects of databaseperformance, configuration (inc virtualizeddatabases and Exadata), schema, RAC andsecurity vulnerabilitiesToad for OracleProfessionalEdition Toad for Oracle Toad DB Admin Toad for OracleDeveloperXpert Edition Module (add-on)Edition Generate reports on potentially problematic SQLand optimization results Toad for Oracle Toad for OracleDBA Edition DBA RAC/ExadataEditionDatabase AdministrationSupport for Oracle 19c multi-tenant databases onpremise and in the cloud (Oracle and Amazon AWS). Move Oracle 19c PDBs from on-premise to OracleDatabase Cloud Service Move schemas and data from on-premise to OracleDatabase Cloud Service Browse multiple servers and databases, performtasks and drill down to object level Browse and navigate database-specific objects liketablespaces and roles Direct access to Oracle Alert log and OracleTrace files to quickly diagnose issuesManage database objects, such as tablespacesand rollback segments Display performance metrics from V , GV and SGA Check database for usage of Oracle OEM Optionsand Management Packs* and produce reports Execute one or more scripts against one or more DBsQuest Software Inc Updated January 2021

Toad for Oracle Editions 2020 R2 Functional MatrixToad forOracle DBAEditionToad for OracleDBARAC/ExadataEdition Playback historical activity on Oracle instances tofind the source of performance issues Simple, highly visual alert-based point-and-clickproblem resolution for Oracle databases includingcontextual launching from Toad (Spotlight) Simple, highly-visual, alert-based point-and-clickproblem resolution for Unix, Linux or Windows Performance diagnostics for Oracle Data Guard Simple, highly visual alert-based point-and-clickproblem resolution for MySQL databases Monitoring of Oracle OEM Perform database predictive diagnostics to pre-emptand mitigate future performance bottlenecks Toad for OracleBaseSubscriptionToad for OracleProfessionalEditionIntegrate with OEM's performance pack withOracle Tuning Advisor * Identify top sessions and resource-intensive SQL Performance Diagnostics and Tuning(Oracle instances)Perform over 200 database health checks includingPerformance Configuration and Storage featuringVirtualized environmentsCollect data from Oracle StatsPack or AWR * anddisplay advisories to correct potentialperformance issuesManage space, repair chained rows andestimate space usageQuest Software IncToad for Oracle Toad DB Admin Toad for OracleDeveloperXpert Edition Module (add-on)EditionUpdated January 2021

Toad for Oracle Editions 2020 R2 Functional MatrixPerformance Diagnostics and Tuning andChange Management (Oracle RAC andExadata)Toad for OracleBase EditionToad for OracleProfessionalEditionToad for OracleToad for Oracle Toad DB AdminDeveloperXpert Edition Module (add-on)EditionPerform over 200 database health checks includingOracle RAC configuration and Exadata Toad forOracle DBAEditionToad for OracleDBARAC/ExadataEdition Simple, highly visual alert-based point-and-clickproblem resolution for Oracle RAC and Exadata Visualize instance, cluster and interconnect levelsfor Oracle RAC performance diagnostics Launch Spotlight on Oracle directly in contextwith an instance exhibiting performance issues Playback historical activity to find the source ofperformance issues Perform industry standard benchmark teststo determine optimum CPU/node config. Replay database workload to simulate productionload levels in a test Oracle RAC environment prior todeployment or implementation of RAC configuration,database or platform changes Visualize and diagnose real-time performanceproblems in Oracle Exadata environments includingstorage server nodes, Smart Scan and Smart FlashCache (Spotlight) Sensitive Data Protection (Add-on Module)**Customizable classification rules library to assistwith sensitive and personal data classification Sensitive data search for scanning across Oracledatabases (metadata and data polling) Quest Software IncUpdated January 2021