Support Center
Explore, Analyze & Document your Code
  1. Home 
  2. VE for Oracle 
  3. Using Toad and VE 

New companion tools for Toad for Oracle

Combine Visual Expert and Toad for Oracle, for unparalleled efficiency in Maintaining and Optimizing Oracle PL/SQL code.

Try Visual Expert

Visual Expert and Toad for Oracle used together to maintain and optimize PL/SQL code

TOAD for Oracle

Toad for Oracle is a development and administration solution that lets you carry out day-to-day tasks efficiently and accurately. Toad for Oracle is the most advanced and widely used solution on its market.

 

Primary features:
Code editing and debugging

Visual Expert for Oracle

Visual Expert for Oracle performs in-depth analysis of your code, to gain a better understanding and facilitate the maintenance of your code.

Dependency mapping, advanced code review and performance analysis features make it the perfect complement to Toad for Oracle.

Primary features:
Code analysis, Cross-references, Continuous Code review

Features

TOAD

Visual Expert
Code Editing Yes No
Debugging Yes No
Code Documentation No Yes
CODE ANALYSIS
At object level Yes Yes
At application level No Yes
Impact Analysis No Yes
CRUD Matrix No Yes
Object Dependency Matrix (ODM) No Yes
Call Graph No Yes
PERFORMANCE
SQL Optimization Yes During Programming Yes After analysis
Performance analysis No Yes
Locate bottlenecks No Yes
Missing Index No Yes
Slowest objects No Yes
Most Used objects No Yes
CODE REVIEW
Defect detection during programming Yes No
Application-wide statistics and reports No Yes
Duplicate Functions No Yes
Dead Code No Yes
Automate code review in a CI/CD pipeline No Yes

How it works

Toad retrieves analysis data directly from the Oracle database, providing real-time information and optimizations based on the current state of the database.

Visual Expert generates its own analysis data, enabling a deeper and more comprehensive examination of the code.

This approach provides more data, at object and application level, unlocking many additional analysis functions to understand code structure, identify problems, and continuously optimize it safely and efficiently.

how it works

Using Visual Expert with Toad

Daily Maintenance

1. Analysts use Visual Expert to:

  • Analyze the entire application
  • Understand its inner workings
  • Identify required changes
  • Dispatch changes among developers

2. Developers use Visual Expert to:

  • Assess the impact of these changes

3. Developers use Toad to:

  • Open the objects to be changed
  • Analyze/Edit/debug object if needed
    (SQL Optimizer for instance)
  • Perform the changes

Code Review

1. Analysts or DBA use Visual Expert to:

  • Analyze the entire application
  • Find bugs, quality, and security issues
  • Identify performance problems
  • List the corrections required
  • Dispatch changes among developers

2. Developers use Visual Expert to:

  • Assess the impact of these changes

3. Developers use Toad to:

  • Open the objects to be improved
  • Analyze/edit/Debug the object
  • Optimize SQL/Index
  • Fix the problem

Visual Expert Unique Features

Cross References

Deep Impact Analysis

Visual Expert impact analysis showing dependencies across referenced Oracle items
Visual Expert performs a comprehensive impact analysis across all referenced items, providing precise insights into dependencies and potential effects on tables, columns, procedures, and other database objects.

CRUD Matrix

Two-dimensional CRUD matrix showing Create, Read, Update and Delete operations on tables
Visual Expert generates a 2-dimensional CRUD matrix, offering detailed visibility into Create, Read, Update, and Delete operations, while illustrating interactions and data flow across multiple tables and columns.

Object Dependency Matrix

Object dependency matrix showing relationships between tables, views and procedures
This matrix provides a detailed view of the relationships and dependencies between tables, views, procedures and other database objects, enabling you to understand how changes may affect interconnected components.

Call Graphs

Call graph showing the hierarchy and flow of Oracle function calls
Visual Expert generates call graphs as tree views and diagrams, illustrating the hierarchy and flow of function calls, which is essential for understanding and optimizing complex code structures.

Code Review

Code Inspection Dashboard

Visual Expert code inspection dashboard with application-level code quality metrics
The Visual Expert Dashboard provides key application-level metrics, giving crucial information on code quality and maintenance requirements. It helps pinpoint potential problems, track progress and make data-driven decisions to ensure optimal code maintainability and reliability.

Code Clean Up

Visual Expert identifying dead code and duplicated functions for clean-up
Visual Expert helps to clean up code by identifying dead code and duplicated functions, streamlining the code base. This helps improve maintainability and guarantees cleaner, more reliable applications.

Naming Rules

Visual Expert checking database naming rules against coding standards
Visual Expert checks naming rules across the database to ensure that all objects follow established coding standards and conventions. This functionality helps maintain consistency, readability, and manageability of the codebase, making it easier for developers to understand and work with the database structures.

Continuous Code Inspection

Visual Expert integrated into a CI/CD workflow for continuous database code inspection
Integrating Visual Expert into CI/CD workflows allows for automatic inspection of database code to detect anomalies, ensure coding standards compliance, and monitor code quality in real time. Early detection and resolution of issues like code smells and security vulnerabilities help maintain a robust and reliable database environment.

Performance Analysis

Find missing indexes

Visual Expert listing queries that target tables without an index
Visual Expert identifies queries with WHERE, GROUP BY, or HAVING clauses targeting tables without indexes. This helps developers prevent full table scans, ensuring the application runs more efficiently.

Find the slowest objects

Visual Expert ranking the slowest database objects by execution time
Identify the slowest objects to systematically target and optimize resource-intensive operations, and ensure that the most critical performance issues are addressed first.

Find bottlenecks

Call graph annotated with execution times to locate bottlenecks in a chain of calls
Identify bottlenecks in a chain of calls by visualizing the execution times of each element. This feature provides you with detailed insights into the execution flow, allowing you to pinpoint specific components causing delays.

Visual Expert Pricing & Editions

Pricing in Euro

    • Basic

      For individual developers with small projects

      $655 /user
      /year
      500 000 Lines of Code
      • Installation on a Client PC
      • Cross-References / Impact Analysis
      • Code Inspection
      • Performance Tuning
      • Code Documentation
      • Updates

    • Professional

      For teams managing large codebases and requiring collaboration tools

      $1,320 /user
      /year
      5 million Lines of Code
      • All Basic Features, plus:
      • Client/server configuration
      • Web Client available
      • Collaborative Features
      • Integration with DevOps Platforms
      • Code Comparison
      • Code Analysis Scheduler & History
      • Updates
      Need more than 5 million Lines of Code?
      Get Volume Discount

    • ENTERPRISE AI

      For teams managing large codebases and requiring AI-powered features

      $1,970 /user
      /year
      5 million Lines of Code
      • All Professional plus AI Features :
      • 10,000 AI Credits per user
      • (AI) Explain the Business
      • (AI) Explain the Logic
      • (AI) Add comments in the code
      • (AI) Fix a problem
      • (AI) Optimize SQL & Code
      • Updates
      Need more than 5 million Lines of Code?
      Get Volume Discount
      • Mandatory for the 1st year
      • Premium Support - $1,979

Visual Expert Featured Resources


Videos