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, insetr, 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
a 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 an hyperlinks 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(1), 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).
(1) This requires Visual
Expert for PowerBuilder |
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 Transact-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. |
Características detalladas
Leer más acerca de Visual Expert para PL/SQL (product
review).......pulse aquí
Solicite una versión de evaluación de
Visual Expert para Oracle
Solicite
una versión de evaluación de Visual
Expert y prúebelo en su propia aplicación.