0 Oracle SQL Pattern Recognition – introducing the Match Recognize operator
Oracle Database Release 12c (12.1) introduced a new operator that we can use in SQL queries. The MATCH_RECOGNIZE operator allows…
Author Lucas Jellema
Lucas Jellema
Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director for Fusion Middleware. Consultant, trainer and instructor on diverse areas including Oracle Database (SQL & PL/SQL), Service Oriented Architecture, BPM, ADF, JavaScript, Java in various shapes and forms and many other things. Author of the Oracle Press books: Oracle SOA Suite 11g Handbook and Oracle SOA Suite 12c Handbook. Frequent presenter on conferences such as JavaOne and Oracle OpenWorld. Presenter for Oracle University Celebrity specials.
0 New PL/SQL pragma (12cR2) to deprecate program units – sign of a modern programming language
Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2.…
0 Next Step in Row generation in Oracle Database 12c SQL using JSON_TABLE
One of those things SQL developers are frequently looking at is the generation of rows: having a query return records…
0 Publishing applications to Application Container Cloud Service from Oracle Storage Cloud
This weekend, while preparing for a demo during Oracle OpenWorld 2016, I found a for me new way of publishing…
0 Access the original calling context in a callback function in TypeScript
While working on my Ionic 2 application, I made use of the exif.js library (for extracting meta-data from image files).…
0 Using and including a 3rd party JavaScript library in an Ionic 2 and Angular 2 [typescript] application
While working on a Ionic 2 (and Angular 2) application, I needed to make use of a 3rd party library…
2 Creating (near) native mobile web app (aka progressive web app) for iOS with Ionic 2
It has been a long standing ambition of mine to create an app that I could run on my iPhone.…
2 Force Text to UpperCase in RichInputText as the user is typing (make sure the cursor stays in one place)
The challenge is simple: users of an ADF Faces web application are only allowed to enter uppercase characters into a…
1 AMIS25 Beyond the Horizon Conference – Session Resource Repository
Below you will find an overview of all the sessions that took place at the AMIS25 Beyond the Horizon conference…
0 Graphical file explorer tool on top of Oracle Storage Cloud Service – CloudBerry for easy file inspection and manipulation
The Oracle Storage Cloud Service is an IaaS offering that underpins [almost] every other PaaS Cloud Service from Oracle. I…
0 Open Letter to managers and team leaders of Oracle professionals – the quickest route to brain fuel
Dear manager or team leader of Oracle professionals, If you have Oracle professionals in your team –whether they are DBAs,…
0 Open Brief aan Oracle Professionals – gun jezelf twee dagen kennismaking met je toekomst – op 2 en 3 juni 2016
Beste Oracle professional, Of je nu PL/SQL ontwikkelaar bent, DBA, ADF ontwikkelaar of SOA Suite specialist, de nieuwsgierigheid blijft altijd…
1 Oracle Cloud – DBaaS instance down for no apparent reason – (how archive log mode and storage shortage forced the instance to its knees)
My Oracle Public Cloud DBaaS instance did not respond. On closer investigation, it turned out to be down. Mounting the…
![2018836700[1]](https://i0.wp.com/technology.amis.nl/wp-content/uploads/2015/01/20188367001.jpg?resize=351%2C185&ssl=1 "Parse JSON Array in SQL and PL/SQL – turn to a Nested Table")
2 Parse JSON Array in SQL and PL/SQL – turn to a Nested Table
Transferring data between technologies and application tiers is done using various formats – binary, native on the one hand and…
2 Create and Run Docker Container with Node.js and Node Oracle DB Driver from Windows using Vagrant and VirtualBox
My objective: be able to very quickly run Node.js applications that can connect to an Oracle Database – with minimal…
0 Running node-oracledb – the Oracle Database Driver for Node.js – in the Pre Built VM for Database Development
Node applications may want to have access to databases – similar to access to the file system, external APIs over…
1 Introducing Oracle Real-Time Integration Business Insight – complement to SOA Suite & Service Bus
The launch of Oracle Real-Time Integration Business Insight – a name that suggests Larry’s direct involvement in naming the product…
0 Leveraging the Twitter Adapter in ICS – Tweeting through Oracle Integration Cloud Service
The Oracle Integration Cloud Service – ICS – comes loaded with a rich collection of Cloud Adapters. These adapters facilitate…
1 Introducing: The Client Side Event Bus in Oracle JET for decoupled interactions across templates, view models and modules with Knockout Postbox
Well organized exchange of client side events has been something of a holy grail for client side web development to…
0 Master – Detail synchronization in an Oracle JET rich client application against a REST API
In a recent article (Extend Oracle JET with Table on REST API and Deploy to Node.js in Application Container Cloud)…