Split a string again and again

I recently needed to gather multiple columns from multiple rows into one string, then split them out again. JSON_TABLE did both splits at the same time!

Live Virtual Fluid Training in July

In the Northern hemisphere, with days getting longer, and temperatures rising, many of us seek wet forms of recreation to keep cool. With the heat of summer upon us, I can't think of a better topic to study than the cool topic of PeopleSoft Fluid. That is why we are offering a remote live virtual Fluid training class during the hottest week of July. Additional details and registration links are available on our live virtual (more...)

AWS DMS – Target TableName Differs

AWS DMS is a tool that supports both homogenous and heterogeneous migration, helping to migrate to aws cloud.

During most of the migrations, the source and target table names remain the same, in which case the Mappings.json file is pretty simple. As an example (Oracle to PostgreSQL)

            "rule-type": "selection",
            "rule-id": "1",
            "rule-name": "1",
                "schema-name": "DEVO",
                "table-name": "TEST_DEMO"
            "rule-action": "include"
            "rule-type": "transformation",
            "rule-id": "2",
            "rule-name": "2",

Need Help with Oracle Security GDPR Training and Services

I talked here a few days ago about GDPR in general and I also published my slides from my talk GDPR for the Oracle DBA . We have been helping clients secure data in their Oracle databases and training people....[Read More]

Posted by Pete On 09/06/18 At 04:33 PM

Oracle Cloud Orchestration

Oracle Cloud has a pretty cool concept (Orchestration) to recreate an instance; however, it’s all hard coded.
The orchestration cannot be shared with some else to create the configuration with different name or from different account.
What version is the Orchestration and shouldn’t it be in the metadata.

"account" : "/Compute-601138841/default",
"description" : "",
"tags" : [ ],
"name" : "/Compute-601138841/me@yahoo.com/qs-classic",
"objects" : [ {
"account" : "/Compute-601138841/default",
"desired_state" : "inherit",
"description" : (more...)

nlOUG Tech Experience 2018 : The Journey Home

The trip home from nlOUG Tech Experience 2018 started pretty early, so true to form I didn’t sleep properly, for fear of sleeping through my alarm. At about 04:00 I was in the bath watching YouTube videos. 🙁

A couple of hours later I was at the station in Amersfoort waiting for the train to the airport where I was joined by Sabine Heimsath. Pretty soon we were on the train, where I made use of (more...)

Challenges and Pitfalls of Data Visualization

"A picture says more than a thousand words". This sounds like a true statement. While it's true that it is easier to tell a story with visuals than with words, it makes a huge difference which visual you are using for which story. What is the real story behind a visual. Using the wrong visual to tell a certain story can reduce the benefit of a visual to zero. In this presentation we will go (more...)

nlOUG Tech Experience 2018 : Day 2

I had a rough start to day 2 of nlOUG Tech Experience 2018. The night before I was in bed and foolishly checked my email only to find some problems at work. I got out of bed, logged in and was checking out the impact of a storage fault. Some databases had been down and some app servers weren’t exactly happy. It was some time after midnight when things started to stabilise out. That meant (more...)

Check inside your APEX application if debug mode is enabled

Sounds like a simple task but whenever I have the requirement to add a region and make it conditional to check if APEX is running in debug mode. I always search for half an hour finding the right solution.

Search example on Google: "Oracle APEX check debug mode conditional PL/SQL"
Trying this or 30 different other ways it always ends up with the wrong results.

But it is so easy - Conditional PL/SQL Expression:

Neue Oracle VM Appliance

Nur damit ich es irgendwo verlinkt habe: Jeff Smith weist darauf hin, dass im OTN eine neue VM mit Oracle 12.2, SQL Developer 18.1, Oracle REST Data Services 18.1 etc. zur Verfügung steht.

Massive Delete

The question of how to delete 25 million rows from a table of one billion came up on the ODC database forum recently. With changes in the numbers of rows involved it’s a question that keeps coming back and I wrote a short series for AllthingsOracle a couple of years ago that discusses the issue. This is note is just a catalogue of links to the articles:

The AskTOM data model

I popped out a tweet yesterday in Throwback Thursday style showing the date of the first question we took AskTOM – 18 years ago! Many entire computer systems don’t even last that long, and AskTOM hasn’t really needed to change that much in those 18 years.  We’ve added a new skin, added the ability to have multiple AskTOM experts on the answer team, and of course, our new-for-2018 Office Hours program, which gives everyone (more...)

nlOUG Tech Experience 2018 : Day 1

Day 1 of nlOUG Tech Experience 2018 started with me missing the opening keynote to spend time talking with Frits Hoogland about all things Vagrant, Ansible and Docker…

The first session I went to was Penny Avril & Dominic Giles with “What’s New from Oracle Database Development”. This was a quick run through some of the key features that have been introduced in 12.2 and 18c, which sets the scene well for some of (more...)


The ability to make grants on objects in the database such as tables, views, procedures or others such as SELECT, DELETE, EXECUTE and more is the cornerstone of giving other users or schemas granular access to objects. I say granular....[Read More]

Posted by Pete On 07/06/18 At 06:58 PM

“Call me!” Many many times!

Some readers might recall that classic Blondie track “Call me”.  Of course, some readers might be wishing that I wouldn’t harp on about great songs from the 80’s. But bear with me, there is a (very tenuous) link to this post. If you haven’t heard the song, you can jump to the chorus right here.  Go on, I’ll wait until you get back. Smile

This golden oldie is relevant when it comes to dealing (more...)

nlOUG Tech Experience 2018 : The Journey Begins

The trip to nlOUG Tech Experience 2018 started at a pretty normal time. I left the house at 08:00, which was far too early really, but you never know about the traffic when you are in rush hour, so I thought it better to be safe than sorry. Rather than the normal 30 minutes, it took about an hour to get to the airport, but once there I breezed through security and had a full (more...)

Wireframing or Prototyping: Which One to Use

While clients tend to tell developers to skip wireframing and prototyping, seasoned veterans tell newbies that they can skip wireframing and proceed with prototyping. Experienced developers believe that interactive prototyping isn’t useful when presenting a project. For example, if the … Continue reading ?

Hat Tip To: MockupTiger Wireframes

Last Week in Stream Processing & Analytics – 6.6.2018

This is the 117th edition of my blog series blog series around Stream Processing and Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

Apache Kafka / Kafka Streams / Confluent Platform

Facebook, Google and Custom Authentication in the same Oracle APEX 18.1 app

Oracle APEX 18.1 has many new features, one of them is called Social Login.

On the World Cup 2018 Challenge, you can see the implementation of this new feature. The site allows you to sign-up or login with Facebook, Google, and your own email address.

It's even nicer that if you register with your email, but later decide to sign-up with Google or Facebook, it will recognize you as the same user if (more...)

Oracle SOAR ?!

Larry Ellison announced yesterday Oracle SOAR:

Soar [https://en.oxforddictionaries.com/definition/soar]:  
Fly or rise high in the air.
‘the bird spread its wings and soared into the air’
It is about migrating into the cloud [press release]:
the world’s first automated enterprise cloud application upgrade product that will enable Oracle customers to reduce the time and cost of cloud migration by up to 30 percent. By providing a complete set of (more...)