Category: Database
Lucas Jellema
October 2, 2013
APEX, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, Java, Oracle, Oracle 12, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter
On Thursday 10th of October, the 12 man strong AMIS delegation at Oracle OpenWorld and JavaOne 2013 will present its findings in a 3 hour session at AMIS HQ …
In this article a second brain dump with observations from the Oracle OpenWorld and JavaOne conferences. These are fairly raw notes – primarily for my own consumption. They may …
Imagine this: You have consolidated you applications into one database (version 10gR2). You take a full backup every Tuesday and Thursday evening and an archivelog backup every few hours. …
Lucas Jellema
September 19, 2013
APEX, Business Process Management (BPM), Cloud, Data Warehousing & BI, Microsoft Azure, Oracle 12, Oracle Application Development Framework, Oracle E-Business Suite, Oracle WebLogic Server, SOA, WebCenter
As I am about to start my ninth Oracle OpenWorld Conference, I am wondering what this year’s conference will have in store for me. My schedule is largely filled …
Saskia van der Maat
September 6, 2013
AMIS, Cloud, Development Tools, Java, Mobile, Oracle, Oracle 12, Oracle Application Development Framework, Oracle WebLogic Server, SOA, Tools, Web HTML5 CSS3, WebCenter
Op 22 september begint in San Francisco de Oracle OpenWorld: hét internationale evenement waar Oracle haar productstrategie presenteert en Oracle-specialisten ervaringen uitwisselen. Naast Oracle OpenWorld wordt ook de JavaOne …
The story of NOPERU – the National Organization for Permits for Emissions and Resource Usage – is an interesting one. Because it reveals the business drivers for embarking on …
Steven Feuerstein, dé PL/SQL autoriteit, komt op 12 en 13 december naar AMIS in Nieuwegein. Twee dagen lang verzorgt hij een masterclass waar u intensief door hem persoonlijk gecoached …
Saskia van der Maat
July 31, 2013
AMIS, Cloud, Data Warehousing & BI, Database, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter, XML
Vanaf 22 september vindt in San Francisco de Oracle OpenWorld conferentie plaats: hét evenement waar Oracle haar productstrategie uit de doeken doet en waar Oracle specialisten van over de …
In a recent post (https://technology.amis.nl/2013/07/24/oracle-database-12c-find-most-valuable-player-using-match_recognize-in-sql/) I described how we can use the new Oracle Database 12c MATCH_RECOGNIZE operator to spot patterns in records and derive results from those patterns. …
One of the very nice new features in SQL in Oracle Database 12c is the MATCH_RECOGNIZE operator. MATCH_RECOGNIZE adds a facility for spotting patterns in records. This allows us …
Flashback started out as a feature in Oracle Database 9i. Although to be honest it is just the opening up of a mechanism that has been at the core …
I am first and foremost a developer. I am not an administrator. I know more about IDEs and GUIs than about command line. I have always been a little …
I have a confession to make. I have not been into Linux very much. When I started my career at Oracle, back in 1994, I had to do a …
When a record is no longer active – it is logically discarded – you may want to delete it. However, the record may still be required – for compliancy …
XMLIndex support for Hash Partitioning is now also supported in Oracle 12c. In Oracle 11 there was already support for RANGE and LIST partitioning, but not yet for HASH …
There is a new default in town. Mark my words, you will encounter the following during your 12c life-cycle… 😉 From the Oracle 12c Reference manual PGA_AGGREGATE_LIMIT: PGA_AGGREGATE_LIMIT PGA_AGGREGATE_LIMIT …
New in Oracle 12c and one of the big new features in XMLDB is the XQuery Full Text functionality and, as mentioned in the post about XQuery Update, is …
New, new…? No, not really new, XQuery Update (W3C standard/draft 2011) was already implemented in 11.2.0.3.0, but is now officially also announced. Besides the XQuery Full Text support (XQFT …
Afgelopen dinsdag is Oracle Database 12c beschikbaar gekomen, de nieuwste generatie van de Oracle database. AMIS biedt Oracle professionals de eerste mogelijkheid om de vernieuwingen in Oracle Database 12c …
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical Functions. Functions that basically allow the result for one …
Joining is a key ingredient in most SQL queries. Using collections (aka nested tables) that are produced on the fly inside the SQL query or that are returned by …
A small enhancement, but what a golden nugget! At least that’s what I think. 😉 It is now possible in Oracle 12c to export data via a view. I …
Oracle Database 12c ships with a brand new supplied package called UTL_CALL_STACK. This package provides an API for inspecting the PL/SQL Callstack. The package complements the DBMS_ UTILITY.FORMAT_CALL_STACK …
The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a …
Oracle DB Express is the new replacement for Oracle DB Console in the Oracle 12c database. Here are some first steps to get started. Oracle DB Express makes use …
Is this one of my highlights? No not really, but it is a remarkable one. Oracle XMLDB functionality is now mandatory and can not be uninstalled. As mentioned in …
At long last it’s here: Oracle Database 12cR1. The download of this fresh software package is hardly done. It is time to start sharing some of our early experiences …
Today was the first day of the two day Masterclass “Understanding Storage” by James Morle at AMIS. After having reserved my participation in this Masterclass on March 12th, the …
It was fairly difficult to come up with a title for this article that sort of covers the content. To me it is quite clear what this is about …
To be useful, data held and used in information systems has to live up to a number of expectations. The data should be an accurate representation of its source. …
Hierbij nog dank voor allen die aanwezig waren bij de weer gevulde, informatieve & gezellige avond tijdens “Hotsos Revisited 2013”. Wij presentatoren hebben genoten van het ambiance. Hier ook …
AMIS is spending a lot of effort keeping our people up-to-date with the latest knowledge needed to help our customers the best way we can. Traditionally we also always …
Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning. …
Using Oracle SQL to resolve meaningful and slightly less serious challenges is one of my favorite (semi-)professional pastimes. In the last two weeks, I have been presenting on various …
It has been a while that I have been attending Hotsos, although that is how it feels. In 2011 I flew to Hotsos to see, among others presentations from …
The challenge in this article is a simple one. I have a table with records (duh!) and each record describes the occurrence of a certain payload. In this example …
I use subquery factoring a lot, to make my SQL queries easier to write. This basically means that most of my queries these days start with WITH rather than …
Data Constraints are essential in protecting the integrity of the data in any relational database. The Oracle Database provides four types of declarative constraints that help implement various types …
The challenge I will address in this article is the following: I would like to provide a nice presentation of data aggregated by time period. For example: an overview …
While working on a Web application that required some page to report data aggregated on several levels of time period – by month, quarter or year – I ran …
