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.
See an example |
| Code Architecture |
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.
See an example |
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.
See an example |
| 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 (click
here to read about regular expressions).
* You may search into a selection of components (for instance
after selecting some procedures in the treeview). |
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.
See
an example
If you also develop with PowerBuilder, all PB references are
included in the result
(read more about Visual
Expert for PowerBuilder) |
PL/SQL
Procedures
and Functions |
Visual Expert can
also list all PL/SQL components calling a procedure or a function.
See
an example
If you also develop with PowerBuilder, all PB references are
included in the result
(read more about Visual
Expert for PowerBuilder) |
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.
See
an example |
| 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.
See an example |
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)
(read more about Visual
Expert for PowerBuilder) |
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. |
Main Features
Read more about Visual Expert for PL/SQL (product review).....click
here
Request an evalutation version of Visual
Expert for Oracle
Request
an evaluation version of Visual Expert and test
it on your own application.