Main
Features
Navigation in the application
With Visual Expert's treeview, explore your PL/SQL components (Packages,
functions, procedures, blocs, triggers...) and their relathionships.
With Visual Expert code browser, navigate in your code like you
never did before: any reference found in the code comes with a hyperlink
to jump to the referenced item. |
Take
the tour |
Impact analysis
If you need to change a stored procedure, a table, a column... Visual
Expert can list all components related to this item. This will help
you evaluate the consequences of the change.
For instance, you can ask for all triggers, cursors, functions and
procedure including SQL statements using a DB column, as well as
a %rowtype definition.
In case you developed PowerBuilder applications any PowerBuilder-to-PL/SQL
reference is also taken into account.
Why use Visual
Expert
Avoid unexpected Side Effects
after a change
When you modify the source code of the application, there is always
a risk of regression and errors due to the modifications. In a click
Visual Expert helps you perform an impact analysis on any component
of the application you are about to modify.
Share the knowledge of your application
Visual Expert makes it easier to navigate, no matter how complex
the application is.
Visual Expert helps you gain time in the development and maintenance
It facilitates the integration of new developers.
When someone is not available, any member of the team can understand
and master his code.
Visual Expert allows you to :
- Discover the application structure and its components
- Explore the inheritance tree and master the framework,
- etc...
|
|
| Detailed
Features |
| |
 Code
Exploration
Impact
Analysis
PL/SQL
References
Database
References |
|
|
| CODE EXPLORATION |
| |
Stored Procedures |
|
| |
After analysing your project, Visual expert may display
several lists of Procedure:
* List of the procedures defined in your project
* List of the procedure referenced by your project (no matter if the
code is included in the project)
* Procedure by Access type (Procedure including Delete, Update, Insert
or Select Statements)
* Procedures which name and/or source code contain a given string
* Procedure called by PowerBuilder Components(1)
(1) This requires Visual Expert for PowerBuilder |
| |
SQL Queries |
| |
After analysing your project, Visual expert may display
several lists of Procedure:
* SQL statements defined in the project.
* SQL statements by access type (select, insert, update or delete
Statements).
* SQL statements by definition type = defined in PL/SQL code, PowerBuilder
Script(1) or Datawindow (1).
* SQL statements containing a given string (text search focused on
the SQL statements of the project).
(1) This requires Visual Expert for PowerBuilder
You may also select packages, procedures, functions, block, triggers
or cursors and list all SQL defined in the selected items. |
| |
Code Architecure |
| |
First, you may select one or several packages, procedures,
functions, block, triggers or cursors. Then Visual Expert will open
a treeview with the architecture of the code of the selected items. |
| |
Hyperlink Exploration |
| |
When displaying your code, Visual Expert adds a hyperlink
for each reference found.
Clicking on this hyperlink will open the source code of the referenced
item |
| |
PL/SQL Components |
| |
Lists of the Packages, Procedures, Functions, Blocks,
Triggers, Cursors and Aliases defined in the application. Each list
open in Visual Expert treeview. |
| |
String search |
| |
You may search for a string in your project. Several
options are available:
* Global Search in the whole project
(including PL/SQL code, PowerBuilder Code, SQL files, ...).
* Search restricted to a given type of component
(For instance, you may search for triggers only).
* You may search in the name and/or the source code of components.
* You use regular expressions in a search.
* You may search into a selection of components
(for instance after selecting some procedures in the treeview). |
|
|
|
top |
| IMPACT ANALYSIS (cross-
references) |
| |
Table and Columns |
| |
First, you can select a table or column.
Then, Visual Expert will list the procedures, functions, block, triggers,
cursors... referencing this table or column.
If you also develop with PowerBuilder, all PB references are included
in the result. |
| |
PL/SQL Procedures and Functions |
| |
Visual Expert can also list all PL/SQL components
calling a procedure or a function.
If you also develop with PowerBuilder, all PB references are included
in the result
|
| |
PL-SQL parameters and variables
|
| |
Same concept: Visual Expert can find any reference to
PL/SQL variables and parameters. |
| |
Oracle Datatypes |
| |
Visual Expert can list all variables or parameters declared
with a given datatype.
For instance which variables and parameters are created with the VARCHAR2
datatype. |
| |
Oracle Functions |
| |
You may need to know where a given Oracle function is
used (such as Count, decode, to_char...). Visual Expert will list
every calls to such a function. |
|
|
|
top |
| PL-SQL REFERENCES |
| |
Procedures and Functions referenced
|
| |
First, you may select one or several packages, procedures,
functions, block, triggers or cursors. Then Visual Expert will list
all Procedures and functions, cursors and variables referenced by
the selected items. |
| |
PL/SQL Cursors |
| |
Visual Expert can also list the PL/SQL cursors referenced
by packages, procedures, functions, block, triggers or cursors. |
| |
PL/SQL parameters and variables |
| |
You may list all variables and parameters referenced
in packages, procedures, functions, block, triggers or cursors. |
| |
Calls from PowerBuilder Objects
to PL/SQL Procedures |
| |
If you also develop with PowerBuilder, you may list
all references from PowerBuilder objects to PL/SQL:
* per PBL (list of the Stored procedures called by each PBL)
* per Object (list of the Stored procedures called by each PowerBuilder
Object) |
|
|
|
top |
| DATABASE REFERENCES |
| |
Table and Columns referenced |
| |
While reading your code, Visual Expert will extract
and analyse the SQL queries in your code. As a result, you can list
all table and columns referenced by your PL/SQL code. |
| |
Aliases |
| |
Visual Expert can also list the aliases used in your
SQL queries. |
| |
Oracle Functions |
| |
You can list all Oracle system function (such as Count,
Decode, To_char...) used in your PL/SQL code. |
| |
|
|
| |
|
top |
