Philipp Salvisberg’s Blog

Database centric development

2015-11-23

Update for PL/SQL Cop and PL/SQL Analyzer

Some people asked me to announce the availability of new versions of products on my web site. I guess a blog entry and a Twitter announcement should do […]
2015-05-17

Introducing PL/SQL Unwrapper for SQL Developer

I’m using from time to time the free service Unwrap it! or Niels Teusink’s Python script unwrap.py to unwrap PL/SQL code. Recently I’m confronted more with wrapped code […]
2015-05-05

Cannot Install Extensions in SQL Developer 4 on Mac OS X

Today I could not install any SQL Developer extension on my Mac OS X machine. I did not get an error message during the installation. After a restart of […]
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-04-30

Trivadis PL/SQL & SQL CodeChecker for SQL Developer Released

A half a year ago Trivadis released a command line utility to scan code within a directory tree for guideline violations of the Trivadis PL/SQL & SQL Coding […]
2014-01-04

Multi-temporal Features in Oracle 12c

Oracle 12c has a feature called Temporal Validity. With Temporal Validity you can add one or more valid time dimensions to a table using existing columns, […]
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-5cf1d5ab848f2136251924/] The first view tvd_object_usage_v contains all […]
2013-10-20

Trivadis PL/SQL & SQL CodeChecker Released

In August 2009 Trivadis – the company I work for – released the first version of their PL/SQL & SQL Coding Guidelines. Back then we made […]
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 […]
2013-01-03

Loading Historical Data Into Flashback Archive Enabled Tables

Oracle provides via OTN an import solution for FBA (Flashback Data Archive also known as Total Recall). The solution extends the SCN to TIMESTAMP mapping plus […]