Happy 2018!

Wishing everyone a Happy New Year!

Happy New Year 2018

Happy New Year 2018

How Well a Query Optimizer Handles Subqueries?

At the beginning of December, at the UKOUG Tech17 conference in Birmingham (GB), I presented a comparison of the query optimizers of MySQL 8.0.3 and PostgreSQL 10.1. One of the things I talked about is their ability to handle subqueries. I summarized my findings with the following sentence:

Simple sub-queries that are not correctly optimized were observed.

It goes without saying that such a sentence leaves a lot of questions open. After (more...)

Data Access Layer vs Table APIs

One of the underlying benefits of PL/SQL APIs is the enabling of data governance. Table owners can shield their tables behind a layer of PL/SQL. Other users have no access to the tables directly but only through stored procedures. This confers many benefits:
  • Calling programs code against a programmatic interface. This frees the table owner to change the table's structure whenever it's necessary without affecting its consumers.
  • Likewise the calling programs get access to the (more...)

Jarvis Pizzeria: Creating a Custom Tasklist

Uncategorized
| Dec 31, 2017
So within Process Cloud Service (PCS) we have already shown the tasklist a couple of times. This is the default tasklist that comes with the product. You can use the left hand side filters and handle the actions in the tasks within the task screens.
However, as with all of the ‘one-size-fits-all’ solutions, the tasklist might not be exactly what you need for your organisation or use-case. In this case it is good to know, (more...)

It’s not too late, submit an abstract today!

Everyone knows I enjoy going to conferences. Not only is this a chance to meet many people I know from blogs and twitter finally in real life, but it is also a great learning experience.

At some point, after listening to dozens and hundreds of presentations on various conferences, you might come to a point where you say: I can do this, too! I, too, have something I’d like to show and share.

This is (more...)

Been There

It’s the end of the year and time for a retrospective of some sort so I was thinking of listing the top 10 most popular pages on my blog, but Connor McDonald beat me to it, so I decided to see if I could remember all the countries I’d visited since starting to work with the Oracle software, and here’s the list in alphabetical order:

Antigua
Australia
Austria
Belgium
Bosnia
Brunei
Bulgaria
Canada
China
Croatia
 (more...)

LEAP#365 Driving a Nokia 5110 LCD with the Adafruit library

I’ve been having SPI conflicts with other libraries I’ve used for controlling the Nokia 5110 LCD, so time to pull out the big guns - the wonderful Adafruit library set which includes a PCD8544 module.

I started with a few tests of the hardware and software SPI modes.

As always, all notes, schematics and code are in the Little Electronics & Arduino Projects repo on GitHub hero_image

Oracle Tidbits – December 2017 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in December 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. […]

It’s not about ego … it’s about knowledge

Take a quick look at this blog post by Jonathan Lewis

https://jonathanlewis.wordpress.com/2017/12/30/nvarchar2/

Anyone that has been working with Oracle for any length of time probably knows that Jonathan has a great depth of knowledge in the Oracle database, and is a regular blogger.  But this post is a good example to inspire anyone that is working with Oracle (or any technology for that matter) to start blogging and sharing their experiences with (more...)

It’s not about ego … it’s about knowledge

Take a quick look at this blog post by Jonathan Lewis

https://jonathanlewis.wordpress.com/2017/12/30/nvarchar2/

Anyone that has been working with Oracle for any length of time probably knows that Jonathan has a great depth of knowledge in the Oracle database, and is a regular blogger.  But this post is a good example to inspire anyone that is working with Oracle (or any technology for that matter) to start blogging and sharing their experiences with (more...)

LEAP#364 Classic Nokia Ringtone

For obscure reasons, I wanted a version of the classic Nokia ringtone on an Arduino. So… I transcribed the score in Guitar Pro and tested it in a little sketch.

As always, all notes, schematics and code are in the Little Electronics & Arduino Projects repo on GitHub hero_image

Here’s a quick demo:

Docker-Swarm: Running with more than one manager-node / How to add a secondary manager or multiple managers

Adding additional masters to a docker swarm is very easy. I just followed the documentation:

On the manager i ran the following command:
alpine:~# docker swarm join-token manager
To add a manager to this swarm, run the following command:

    docker swarm join --token SWMTKN-1-3b7f69d3wgty0u68oab8724z07fkyvgc0w8j37ng1l7jsmbghl-5nrni6ksqnkljvqpp59m5gfh1 192.168.178.46:2377
And on the node:
node03:~# docker swarm join --token SWMTKN-1-3b7f69d3wgty0u68oab8724z07fkyvgc0w8j37ng1
l7jsmbghl-5nrni6ksqnkljvqpp59m5gfh1 192.168.178.46:2377

This node joined a swarm as a manager.
The new (more...)

nvarchar2

Here’s an odd little quirk that appeared when I was playing around with default values just recently. I think it’s one I’ve seen before, I may even have written about it many years ago but I can’t find any reference to it at present. Let’s start with a script that I’ll run on 12.2.0.1 (the effect does appear on earlier versions):


rem
rem     Script:         nvarchar2_anomaly.sql
rem     Author:         Jonathan Lewis
rem     Dated:           (more...)

Getting started with Oracle Database in a Docker container!

One of the benefits of using Docker is quick and easy provisioning. I wanted to find out first-hand if this could help me get an Oracle Enterprise Edition database quickly up and running for use in a development environment. Oracle provides Docker images for its Standard and Enterprise Edition database in the Oracle Container Registry. Lucas Jellema has already provided two blogs on this (here and here) which have been a useful starting (more...)

Oracle SQL Developer Data Modeler 17.4

Originally posted on HeliFromFinland:
This is a version I have been waiting: so many important bug fixes! I downloaded it immediatelly the evening it was available and finished one of my projects using it. If you have not downloaded it yet, do it today: http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html Why did I waited for it? Because of, for instance,…

January PeopleTools Training Courses Posted

We posted our January PeopleTools training agenda. This month includes our extremely popular Fluid course as well as our new PeopleTools Delta course. Register online at www.jsmpros.com/training-live-virtual/. Our First course is January 8th, which is coming up quickly.

Besides our regular mid-week agenda, we added weekend courses for those that are committed mid-week and can't take time away for training.

The time zone for these courses is designed to catch as many US (more...)

On hitting 100K on StackOverflow

100,000 is just another number. It's one more than 99,999. And yet, and yet. We live in a decimal cultural. We love to see those zeroes roll up. Order of magnitude baby! It's the excitement of being a child, going on a journey in the family car when the odometer reads 99994. knowing you'll see 100000. Of course everybody got distracted by the journey and next time you look at the dial it reads 100002.

(more...)

Creating a database link using a tnsnames entry

I have had this in my draft posts for a couple of weeks and I refrained from publishing because it was too simple.

However the main purpose of this post is to help others save time by providing useful information. The secondary purpose of to remind myself how I overcame whatever problem is being covered.

A user did not have permissions to edit the tnsnames.ora file on a server so I created the database (more...)

You gotta work harder!

If I take a long hard look at the people *I consider* successful, the main thing I notice is they consistently work hard. They have focus and they put in a lot of hours to get what they want. It doesn’t matter what area it is, you can see the same thing time and time again. The people that work hard get the results. The people that don’t typically fail, or at least don’t live (more...)