0 Building a Conference Session Agenda with Oracle APEX – notes on Pivot, Modal Popup and jQuery
AMIS is part of the Conclusion ecosystem of over 20 companies, each with their own specialty and identity. Several times…
Browsing: sql
0 Some neat APEX tricks while building a Session Like application for our Conference
AMIS is part of the Conclusion ecosystem of over 20 companies, each with their own specialty and identity. Several times…
1 Some Notes on my small steps with Oracle APEX
In this article, I will share some of my personal findings and discoveries as I start out building a small…
3 Quickly developing and hosting your friendly neighbourhood application – for free using … Oracle APEX
My challenge: my wife wants to set up a system for some of our friends and relatives to let each…
0 Building a Conference Session Recommendation engine using Neo4J Graph Database
This article describes a use case for which a traditional SQL-powered relational database approach can provide a solution – but…
4 Querying and Publishing Kafka Events from Oracle Database SQL and PL/SQL
One of the session at CodeOne 2018 discussed an upcoming feature for Oracle Database – supported in Release 12.2 and…
2 Rapid generation of Oracle DDL scripts for Tables, PL/SQL APIs, Sample Data
Yesterday, at the Oracle ACE Directors Product Briefing, I received a gift. It is called QuickSQL. And it is a…
0 Introducing Elastic Search NoSQL to Oracle SQL developers – comparing dozens of ElasticSearch and SQL operations (a bit like Rosetta)
Even for organizations with strong roots in relational databases such as Oracle RDBMS, there may be valuable opportunities for leveraging…
2 Oracle REST Data Services (ORDS)
While preparing for writing an article about “Oracle API Platform Cloud Service” I wanted to quickly be able to generate…
0 Microservices and Updating Data Bound Context on Oracle Cloud with Application Container and Event Hub (plus DBaaS and MongoDB)–Part Two
This article describes – in two installments – how events are used to communicate a change in a data record…
0 Machine Learning in Oracle Database – Classification of Conference Abstracts based on Text Analysis
Machine Learning is hot. The ability to have an automated system predict, classify, recommend and even decide based on models…
0 Oracle Database standard Geo Location Support using Locator (included in every edition!)
Many databases have native support for locations en geodata – and determining distance and closest locations (within a certain perimeter).…
0 The normalization of Big Data – reporting from Oracle OpenWorld 2016 on Big Data and Data Integration
The importance of data has never been in doubt in the world of Oracle. Through machine learning and predictive analytics…
0 The state of the flagship as per Oracle OpenWorld 2016 – Oracle Database 12c Release 2, Exadata Express Cloud Service, SQL and PL/SQL
The new 12cR2 release of Oracle Database had already been announced and discussed at length over the past year. And…
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…
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…
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…
4 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…
0 Reflections after Oracle OpenWorld 2015 – Business Analytics (Big Data, GoldenGate, OBI (EE), ODI, NoSQL)
note: I would like to thank Mark Rittman of RittmanMead for sharing many of this findings from Oracle OpenWorld 2015…
0 MySQL 5.7 – more of a database than you might have guessed
One of the cool stories of Oracle OpenWorld and JavaOne 2015 is the story of MySQL, in particular of release…