Category: Databases
You may have seen we write on Flashback functionality in the Oracle Database. It’s an area that I like – especially since the introduction of the Flashback Data Archive …
This very brief article demonstrates how a fairly complex, nested JSON document can be created using a single SQL query. The main features used in the SQL statement are …
Once upon a time, I had something of a reputation for creating Charts in SQL. Bar Charts, Pie Charts, Gantt Charts and several other unlikely chart types, all created …
One of the topics I discussed in today’s Masterclass Advanced Database Development was inter-session communication – or how database sessions can exchange information. One of my favorite vehicles to …
De Oracle Database is in zekere zin ook een Applicatie Server. Of in elk geval is de database een zeer krachtige infrastructuur die door allerlei soorten applicaties kan worden …
Roel Hartman and me are currently very busy with our Kaleidoscope 2011 presentation “XFiles, the APEX Version: The Truth is in There…“. During this presentation, we will demonstrate the …
There is often a need to synchronize data from a query. For example reading external data and update the tables. Sometimes it can be achieved by a single merge …
In my quest to position ‘connect by’ (and its 11g successor, Recursive Subquery) as mechanism for recursive queries rather than just an hierarchical query facility, I stumbled across a …
Een upgrade naar de nieuwste versie van de Oracle Database vindt zelden plaats op initiatief van het applicatie-ontwikkelteam. Upgrades worden meestal gedaan in verband met support-regelingen, op verzoek van …
In previous articles, I have suggested that the arrival of the Flashback Data Archive in Oracle RDBMS 11g allowed us to finally say goodbye to journalling tables. Keeping track …
The new ready to download Oracle XBRL Extension is a “no cost option” on top of the latest Oracle Database 11.2.0.2.0 release. With this added functionality you will get …
Really getting the most out of your database. That would be nice, given wat databases can do (and what you may have paid for them). Few serious Java Applications …
One of the requirements at my current project is to have one ADF table display data from different database tables. That is, depending on criteria entered by the user, …
In preparation for our Oracle Open World session ‘Xenogenetics for PL/SQ – Infusing with Java Best Practices and Design Patterns’ – I have been doing a little work on …
Back in 2004 when we started with the AMIS Technology Blog, my main objective was to record the things I infrequently do in order to have notes describing the …
Donderdag as. is de AMIS Query van Doug Burns over SQL Tuning, gebruikmakend van de Oracle Enterprise Manager (Tuning en Diagnostics pack). Misschien verwachten velen een hoog “DBA” gehalte, …
AMIS Technology School is proud to present, in collaboration with Miracle Benelux Masterclasses: An Evening with Oracle Database Security Expert: Pete Finnigan on Tuesday 25th of May, 2010. Miracle …
I never find it very easy to try to capture the atmosphere during a conference, the presenting part, the presentations or the discussions, for example, you could have with …
Its Sunday and its raining outside. The nice weather on Saturday (approx. sunny / 20 degrees Celsius) has gone. After a decent flight on Friday where I actually made …
The Oracle Open World 2009 conference is almost underway. On Monday 12th October I will do two presentations, and I am done preparing the first one of them …
One of the most spectacular new facilities in Release 2 of the Oracle 11g Database is called Edition Based Redefinition – not a name perhaps that suggests any spectacle. …
You are probably familiar with the FIRST_VALUE and LAST_VALUE analytical functions that were introduced some time ago into the Oracle RDBMS, in the 9iR2 release I believe (or at …
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in …
I noticed yesterday a new feature that could have the potential to be a small, by me unnoticed, gem called "Flash Cache". I hope someone on the internet, that …
Oracle 11g Release 2 for Linux can now be downloaded via the Oracle Technology Network here: http://www.oracle.com/technology/software/products/database/index.html The documentation and whitepapers can be found via the following link: http://www.oracle.com/technology/products/database/oracle11g/index.html The …
Lucas already gave a very good in depth overview of the "Hotsos Revisited" session last night. It always amazes me how fast he can make a cool blog post …
It’s Monday night and a select company of DBAs and Database developers have gathered at AMIS HQ in Nieuwegein for the ‘Looking Back at Hotsos 2009’ session. It …
Marco Gralike April 22, 2009 AMIS, Announce / Events, Architecture, Book reviews and Publications, Databases, DBA Oracle, Development Tools, IT, Oracle, Tools Begin maart 2009 werd in Irving, Texas, het internationale Oracle Performance Symposium Hotsos gehouden. Ook dit jaar stond het symposium garant voor inhoudelijke hoogstaande presentaties en discussies over performance. Vier …
In a project where i am working on, we needed to show an image and the image should be change when a user would like to do that. For …
My challenge of the day: a query that returns aggregate values. And that can be manipulated dynamically to sometimes aggregate grouped by one dimension, sometimes along multiple or …
In a previous article – Not all has to be black and white in SQL Queries – , I discuss how not all searches are about perfect matches. The …
The other night I had an interesting dinner date: seated around me were an Oracle ACE Director (Mark) and two Oracle employees, experts on Oracle Coherence (Ewan) and Oracle …
One very efficient way of passing data from the Java application to the database is through the use of custom Oracle Types. Even when we want to send a …
In this article something you may never do in exactly this way. Yet something that may become increasingly more useful, as our databases will have ever more Data Service …
While preparing for a whole different topic, I had to create a few demonstrations of using custom SQL Types and Collections in both SQL and PL/SQL. While nothing spectacular …
Today me colleagues Lucas, Gerwin and I got some nice “Oracle Open World Welcome Notification” e-mails from the Oracle Open World 2008 team. We are happy to announce that …
Lucas Jellema May 30, 2008 AMIS, Databases, IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java Thursday 29th May – some 70 Java specialists gathered to discuss the main themes and findings from the 2008 JavaOne conference. Peter, Wouter and Lucas presented on their experiences …
In the year that XML celebrates his 10th anniversary, Oracle announces to make the XQuilla XQuery engine available under the open source Apache 2.0 license. Via official sources, the …
Last week I had to parse thousands of sql insert statements, read from files (one file per table), within a Java environment. These files contain complete SQL insert statements, …
It is nagging… I got an email from that you are able to download the handouts from ODTUG until half September (download them now, 1/2 September they will be …