2 The Inbound File Adapter – Use trigger file
The Inbound File Adapter can be used for polling and processing new files in a specified directory. With the Adapter…
Author Jurgen Kemmelings
Jurgen Kemmelings
Oracle consultant at AMIS
3 New in Oracle 11g: Read Only Tables
In Oracle 11g database it is possible to make a table really read only, also for the owner of that…
0 New in Oracle 11g: wait added to lock table syntax
In Oracle 11g you can add a wait clause to the lock table command in which you can specify how…
5 New in Oracle 11g: PL/SQL Function Result Cache
A new feature in the Oracle 11g database is the ‘Function Result Cache’. When you create a function with the…
1 New in Oracle 11g: the FOLLOWS Clause in Create Trigger Statement
The order in which triggers of the same type fire is arbitrary. But in Oracle 11g the create trigger statement…
1 New PL/SQL Compiler Warning in Oracle 11g
The PL/SQL compiler in Oracle 11g will give you a warning if it encounters a when others exception without a…
4 New PL/SQL Feature in Oracle 11g: the use of sequence.nextval
Another small new feature in Oracle 11g PL/SQL: you can directly use sequence.nextval (and sequence.currval). It is not necessary anymore…
4 New PL/SQL Feature in Oracle 11g: CONTINUE
A minor new PL/SQL feature in Oracle 11g is the new statement ‘continue’. With the continue statement you can skip…
3 Using unique function based index as check constraint
Case: In a table there is a column customer_code and a column status. The allowable values of status are I,…
1 AskTom Live with Tom Kyte! – day two
A short report of the second day of the OakTable Seminar AskTom Live with Tom Kyte! The day started with…
0 Oracle OpenWorld
Last Friday I visited the Oracle OpenWorld conference in Amsterdam. Here’s a short report of my visit. The day started…