2017-07-11

Simplify the Use of PL/Scope in SQL Developer

In this post I showed how to do some code analysis with PL/Scope and how the views and packages of the plscope-utils might simplify this task. However, these views […]
2017-03-17

plscope-utils – Utilities for PL/Scope

PL/Scope was introduced with Oracle Database version 11.1 and covered PL/SQL only. SQL statements such as SELECT, INSERT, UPDATE, DELETE and MERGE were simply ignored. Analysing […]
2014-05-22

Ready for Oracle 12c

The Oracle 12c grammar is now supported in the new versions of the Trivadis CodeChecker, CodeChecker for SQL Developer and CodeAnalyzer. The following example code, copied from a colleague […]
2014-01-02

Column-less Table Access

While writing some JUnit tests after fixing bugs in dependency analysis views, I came up with the following query: [crayon-5ba87d89edaf5890834842/] The first view tvd_object_usage_v contains all […]
2013-07-28

Trivadis PL/SQL & SQL CodeAnalyzer Released

A month ago I had a talk about “Extending the Oracle Data Dictionary for Fine-Grained PL/SQL and SQL Analysis” during the ODTUG Kscope13 conference in New […]
2011-10-12

Using UTL_XML.PARSEQUERY for SQL Dependency Analysis

Last week I had a talk at Oracle’s OpenWorld 2011 titled Modern PL/SQL Code Checking and Dependency Analysis. The problem I described in chapter 4 was […]