Author: Jurgen Kemmelings
The Inbound File Adapter can be used for polling and processing new files in a specified directory. With the Adapter Configuration Wizard you can create this File Adapter Service …
In Oracle 11g database it is possible to make a table really read only, also for the owner of that table. Until now a table could only be made …
In Oracle 11g you can add a wait clause to the lock table command in which you can specify how many seconds you want to wait to get the …
A new feature in the Oracle 11g database is the ‘Function Result Cache’. When you create a function with the new clause ‘RESULT_CACHE’ the result of the function is …
The order in which triggers of the same type fire is arbitrary. But in Oracle 11g the create trigger statement has a FOLLOWS clause. With the FOLLOWS clause you …
The PL/SQL compiler in Oracle 11g will give you a warning if it encounters a when others exception without a raise or raise_application_error. SQL> alter session set plsql_warnings='enable:all'; Session …
Another small new feature in Oracle 11g PL/SQL: you can directly use sequence.nextval (and sequence.currval). It is not necessary anymore to do something like select sequence.nextval into l_seq from …
A minor new PL/SQL feature in Oracle 11g is the new statement ‘continue’. With the continue statement you can skip to the next iteration in a loop. A small …
Case: In a table there is a column customer_code and a column status. The allowable values of status are I, P, C, E. The status indicates that a record …
A short report of the second day of the OakTable Seminar AskTom Live with Tom Kyte! The day started with the last part about analytic functions that we didn’t …
Last Friday I visited the Oracle OpenWorld conference in Amsterdam. Here’s a short report of my visit. The day started with the general keynote session ‘Technology Inspired Collaboration’ by …