Template for “On Logon Trigger”

Posted by on 27/01/2012 No comments

Here are basic instructions for creating a trigger “On Logon”. Sometimes I need to create one on the fly and it is useful to have a template.

Read more »

Oracle CREATE DIRECTORY trick

Posted by on 11/04/2011 No comments

Sometimes you can’t read file owned by oracle user from your unix user.
But if you’ve “CREATE DIRECTORY” privilege you can use a trick.

Read more »

PL/SQL – JDBC mapping (link)

Posted by on 29/03/2011 No comments

I want to share a link, part of the Oracle 10gR2 documentation, which covers the mapping of types (SQL and PL / SQL) supported in JDBC. Mapping Oracle < -> JDBC Among them, unfortunately, is not the type RECORD …

Tom Kyte in Rome

Posted by on 29/03/2011 No comments

Day 4 April the famous expert Tom Kyte will be at the hotel Holiday Inn Parco dei Medici in Rome. There will be a seminar on new features introduced in Oracle 11gR2. The link for registration is this.

Performance of PL/SQL table construct

Posted by on 29/03/2011 No comments

I have collected some interesting data concerning the performance of direct access to PL/SQL tables in SQL constructs. I have collected some interesting data concerning the performance of direct access to tables PL / SQL in SQL constructs. From some …

Read more »