Avoid regression bugs: if you need to change any items in your application (procedure, table, column, variable...) Visual Expert can list all components related to this item. You can then evaluate the consequences of the change and avoid unexpected side effects.
For instance, you can find all SQL, triggers, functions and procedure using a given column.
When maintaining large, old and complex applications, you may need to understand code you’re not familiar with. In such cases, Visual Expert is the perfect companion for your development tool:
Easily explore the code structure and components.
Visual Expert scans your code to provide the following services:
While scanning your code, VE can suggest changes at coding level that will improve SQL performances. For instance, it can find the columns used in “Where” clauses, group by, etc., that don’t have any Index yet.
You can then anticipate performances issues very early in the development cycle, without waiting for testing, profiling or even production…
Generate a complete and customized documentation of your PL/SQL code.
Easily transfer the knowledge of your application.
Navigate between objects using hyperlinks in the documentation.
You can customize the content and presentation of your documentation, and Schedule it to generate it automatically on a regular basis.
See an example documentation here.
With large volumes of code, string searches often return too many results, making such searches tedious and non-productive. Visual Expert addresses this issue as follows: