Visual Expert for Oracle - PL/SQL stored procedures exploration & impact analysis

|
Products
|
Solutions
|
Try Visual Expert
|
Price Request

|
Company
|
News
|
Contact
|
Support
|
Site Map
|
Home


	VE for Oracle
	Detailed Features Flash Demo Try Visual Expert Buy Visual Expert Key Benefits

Visual Expert for Oracle Detailed Features

Why use Visual Expert?

Navigation in the application:

With Visual Expert's treeview, explore your PL/SQL components (Packages, functions, procedures, blocs, triggers...) and their relationships.

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.

Global 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.

Example : Impact Analysis on a table
Click here to enlarge the picture

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...

Trial version of Visual Expert for Oracle

Visual Expert for Oracle Stored Procedures detailed features

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 Procedures and Functions
	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.

Visual Expert for PowerBuilder - Oracle PL/SQL Stored Procedures - Sybase ASE T-SQL Stored Procedures - MS SQL Server T-SQL Stored Procedures
Trial Version : PowerBuilder - Oracle - Sybase ASE - MS SQL Server - Price Request
Impact Analysis - Source Code Documentation - Knowledge Transfer - Code Exploration - Code Review - Update List - Support - News - Contact - References - Site map
Enable for PowerBuilder - PBProtect - Rex - Database Extractor - Visual Guard for .Net - Visual Guard for PowerBuilder visual-expert