PL/SQL Analyzer v0.7.9

• Release on 2014-01-10
• Fixed slash (/) handling in SQL*Plus file preprocessor

PL/SQL Analyzer v0.7.7

• Released on 2014-01-09
• Grammar fixes

PL/SQL Analyzer v0.7.6

• Released on 2014-01-02
• Fixed analysis views TVD_OBJECT_USAGE_V and TVD_SQL_USAGE_V; ensured that named queries of subquery factoring clauses are not considered as table_name

PL/SQL Analyzer v0.7.5

• Release on 2013-12-31
• Grammar fixes
• New analysis views
  • TVD_OBJECT_LOCAL_FUNC_USAGE_V: Locally called functions in static code (package bodies only)
  • TVD_SQL_LOCAL_FUNC_USAGE_V: Locally called functions in captured SQL statements (package bodies only)
  • TVD_SQL_COL_USAGE_V: Used columns in captured SQL statements
  • TVD_SQL_PROC_CALL_V: Potential procedures calls or function calls without parenthesis in captured SQL statements; result contains false positives such as column names
  • TVD_SQL_STRING_USAGE_V: Used strings in captured SQL statements
• Fixed analysis view TVD_OBJECT_COL_USAGE_V to consider table/view synonyms and to include column names within parenthesis
• Unified column set in TVD_SQL… views; available columns are: CAP_ID, SQL_ID, USER_NAME, SCHEMA_NAME, MODULE, ACTION and LAST_LOAD_TIME
• SQL*Plus grammar is now supported in captured SQL statements; however the XML parse tree will contain only the representation of the following commands:
  • CREATE FUNCTION
  • CREATE PACKAGE
  • CREATE PACKAGE BODY
  • CREATE PROCEDURE
  • CREATE TRIGGER
  • CREATE TYPE
  • CREATE TYPE BODY
  • CREATE VIEW
  • CALL
  • DELETE
  • EXPLAIN PLAN
  • INSERT
  • LOCK TABLE
  • MERGE
  • SELECT
  • UPDATE
  • COMMIT
  • ROLLBACK
  • SAVEPOINT
  • SET TRANSACTION
  • SET CONSTRAINT
  • PL/SQL units (anonymous PL/SQL blocks)
• “CREATE TYPE” commands are now processed and included in the view TVD_PARSED_OBJECTS_V for static code analysis
• Automatic repository upgrade procedure based on tvdca version (0.7.5), table version (1), database code version (4), XML parse tree version (4); metadata is stored in the table TVD_METADATA_T
• New command line option “threads” to process Oracle dictionary objects and captures SQL statements in parallel

PL/SQL Analyzer v0.6.8

• Released on 2013-09-23
• Fixed wrong result in column TABLE_OWNER of the view TVD_SQL_USAGE_V
• New analysis views
  • TVD_OBJECT_DOT_IDENT_V: Identifier used with a dot operator in static code, e.g. left_value = ‘DBMS_OUTPUT’ and right_value = ‘PUT_LINE’
  • TVD_OBJECT_PAREN_IDENT_V: Identifier used before parenthesis in static code, e.g. function names, object type constructor calls or associative arrays
  • TVD_OBJECT_PROC_CALL_V: Potential procedures calls or function calls without parenthesis in static code; result contains false positives such as column names
  • TVD_OBJECT_STRING_USAGE_V: Used strings in static code
  • TVD_SQL_DOT_IDENT_V: Identifier used with a dot operator in captured SQL statements, e.g. left_value = ‘DBMS_OUTPUT’ and right_value = ‘PUT_LINE’
  • TVD_SQL_PAREN_IDENT_V: Identifier used before parenthesis in captured SQL statements, e.g. function names, object type constructor calls or associative arrays

PL/SQL Analyzer v0.6.6

• Released on 2013-09-03
• Grammar fixes
  • fixed cleanup issues (wrong results depending on Oracle database version)
  • fixed parsing errors on captured SQL with/without trailing semicolon

PL/SQL Analyzer v0.5.1

• Released on 2013-07-28
• Initial GA Release
• Analysis views
  • TVD_OBJECT_HINT_USAGE_V: Used hints in static code
  • TVD_OBJECT_USAGE_V: Used tables/views in static code
  • TVD_OBJECT_COL_USAGE_V: Used columns in static code
  • TVD_SQL_HINT_USAGE_V: Used hints in captures SQL statements
  • TVD_SQL_USAGE_V: Used tables/views in captured SQL statements
• Analysis table functions
  • TVD_COLDEP_PKG.GET_DEP: View column dependencies