Revising jQuery with Oracle APEX - 17-Aug-2017 10:49 - Scott Wesley
A few years ago I managed to bust out a book that explored my experiences using jQuery within Oracle APEX to solve various problems, many originally explored when building some "backend" apps for use on tablets.

For those who've read my book, thank you and I hope it was useful to you.
(I also hope you read the revised chapter 9 on calling PL/SQL from JavaScript.)
Please let me know what you thought of it with a review on Amazon.

The reason I bring this up is because I was asked on Twitter whether I would do a revision of my book for APEX 5.1.
I'm not sure if you've noticed, but my extra-curricular output has been down this year, despite my best intentions. That's not my answer, but it does weigh into what I think about the answer to that question.

Half of that book was written prior to APEX 5.0 being released. While a lot of the content is agnostic to the version of APEX you have, I must admit my techniques have evolved since the advent of the Page Designer.

That's not to say learning how to apply jQuery within APEX isn't useful. Having these fundamentals are still very much applicable, and useful to know when constructing dynamic actions; and even when defining CSS. But I think because it's much quicker to navigate through your dynamic actions in the Page Designer, I think there is less need to bundle logic within a JavaScript block.

I'm not sure revising this particular book for a later version of APEX would add value.

NASA Cassini
My video course had no particular theme and just explored various APEX techniques, hence the name. My book wasn't much different, and if I was going to do something again in future, it would possibly be along the same lines. Or something
even more applied. I do have ideas.

But I've been enjoying an awful lot of science in the time being. So much going on in space news!
It will be sad to see Cassini finish... Don't be surpised, I already have a post in mind for that amazing project.
In Memory Session State - Simple Example - 17-Aug-2017 10:09 - Scott Wesley
Not too long ago I encountered an interesting behaviour with session state, turns out not long after Dick Dral posted a very similar article that I had not yet seen.

Recently I encountered an even easier scenario.

I had a bunch of columns where I wanted to use the same prefix across all headers, but I wanted to define the value once, referring to it many times. I'm betting on the fact someone may change their mind.

Interactive Report with pivoted data

So I created a hidden item called P222_PREFIX and gave it a static source of "Ch".

Page item source

If I substitute this item as part of the column heading for each column, it will use the value found session state - not the database value, but the value based on the defined source, placed only in memory for the duration of page rendering.

Column heading

So while the output may appear as desired after the page renders, if the region is partially refreshed by hitting "Go" on an interactive report or just triggering region refresh, the prefix will disappear because there is no value for P222_PREFIX in session state once the page finishes rendering.

Desired output

To fix the problem we add a computation on the hidden item to set the value, instead of using a static source. This ensures the value is in session state for current and later usage.

An alternative solution to the task at hand might be to use Shortcuts.
How do I share a URL to my APEX application? - 17-Aug-2017 09:17 - Joel R. Kallman
What is the URL for my APEX application?  If I want to provide a URL to my APEX application to others, what URL do I give them?

Great questions!  I see this done incorrectly all the time inside of Oracle.  A person new to Application Express (APEX) will create an application or install a Productivity Application, run it, copy the full URL, and include the full URL in an email.  I encountered this today in an email, for me to complete a Global Tax Survey via an APEX application (let the good times roll!).  The URL provided was:


Wow, that sure looks complex!  However, it's unnecessarily complex.

The syntax for the entry points into the APEX engine is well documented.  Interpreting the above URL and the colon-separated arguments, it means:

  • 23828 - Application ID
  • 2 - Page ID
  • 113570213685366 - APEX Session ID
  • ::::: - null values for the rest of the arguments in the URL

However, let's evaluate each one of these values in reverse order and assess their necessity:

  • ::::: - Utterly not necessary.  The argument values will default to null anyway.
  • 113570213685366 - Also utterly not necessary.  Assuming the application requires authentication, the APEX Session ID is specific to you, and only you, and only at a specific moment in time.  You'll notice that if you give this URL to someone else, they'll be prompted to authenticate, and then get an entirely new APEX Session ID.  Why include it if it's going to change anyway?
  • 2 - There is a Home URL to every application, so if you're including the starting Page ID in the URL, then it's redundant to include the Page ID again.  It's not necessary.  Additionally, if this is not the same Page ID which is specified in the Home URL, and you have Deep Linking disabled (the default), your end users are going to end up accessing your application via the Home URL anyway.  This is another reason not to include the Page ID in the URL which you share with others.
  • 23828 - This is the only value that is absolutely necessary.  This is the ID of the application you wish to share.

Thus, the URL that I received in email could have been provided simply as:


I don't fault new users to APEX for doing this.  It's not obvious.  But now, hopefully it is!
Build the Oracle APEX application: the framework - 17-Aug-2017 06:11 - Dimitri Gielis
Over the years while developing Oracle APEX application, I noticed in every application I was following the same steps. It was a routine I followed over and over. For example: in every application I created a global page (page 0), enabled Feedback, ran the Advisor multiple times a week, used certain naming conventions etc.

A few years ago I wrote those steps in our APEX R&D development guide, so within our team we would be consistent. Just like the database best practices, I thought it would be a good idea to share the APEX best practices with you as well. There are about 9 pages, here's a screenshot of the first page:
I don't like too many rules, but a few are good to have, especially when you get new people on board or when the customer is working together with you. As I said in my previous post where I described our database guidelines, the guidelines in itself is not meant to be "this is best and you have to follow", it's more something to start from which you can adapt.

Based on those guidelines, we created a "starter application", so you get a head start in your project. The app in itself wasn't spectacular in itself, it contained the global page, feedback, some administrator pages which give statistics of your app, some application items, error handling package etc.

If you know what you have to build, it wouldn't even take that long to build it from scratch. I just don't like to do repetitive things, I far rather concentrate on the real solution, so anything that can help, I will embrace :) I also won't hesitate to take some components or solutions from other projects and reuse those. But just one piece of advice, always check if what you've been doing before, is still valid today and "the best" way of doing it -for your current problem-. For example if you developed something in APEX 4.2, maybe in APEX 5.x there's a build-in package to do that. Or the other way, that a feature of APEX became deprecated (e.g. apex_plsql_job) and you should use a database feature (dbms_scheduler).

In 2015 I also gave a presentation at some Oracle conferences how I developed in APEX 4.2 vs 5.0, which you find here.

So I could use my starter app for this project, but just as with Quick SQL (to create your database objects), there's a new feature in Oracle APEX 5.2 that will make the starter app irrelevant, so I will cover the new way of doing something in 2017 and further.

The new way of building an application, is to start from a "Blueprint". The concept is very similar to my workflow previously, but now it's built-in the APEX Builder and it's more powerful as it allows to customize the features you want to include in your app.

Blueprint is at the time of writing only available in Preview mode (since March 2017) through and will probably undergo some more changes. I see a lot of potential in this feature. It's not only the wizard you can use, rumors are you can also use JSON syntax to define your app.

Here's the video I recorded where I give a bit of background and you see me using Blueprint:

At the time of writing Blueprint isn't finished yet. Not sure what the end result will be, but although there's still a lot of room for improvement, it already looks spectacular. As you could see in the video, I will use it as my starting point for my multiplication table project. I've exported the app of and imported in my Oracle Exadata Express environment. Next I'll make changes to this app and customize further.

Blueprint is (or will become) the fastest and most low code way to build an Oracle APEX application.
Oracle Datenbank (mit APEX) auf Docker - so geht's! - 16-Aug-2017 10:49 - Carsten Czarski

Die Oracle Datenbank ist traditionell auf vielen Plattformen verfügbar. Neben dem Betriebssystem als Plattform, gibt es auch verschiedene gängige Virtualisierungslösungen; und in jüngster Zeit wird die Container-Technologie Docker mehr und mehr populär. Docker unterscheidet sich vom Konzept der virtuellen Maschinen dadurch, dass nicht immer ein eigenes Betriebssystem aufgebaut wird. Vielmehr basieren mehrere Docker Container auf gemeinsam genutzten Ressourcen, so dass die Möglichkeiten des Host-Systems wesentlich besser ausgenutzt werden.

Vor allem Entwickler können Docker hervorragend nutzen, um eine Application-Express-Umgebung nicht nur schnell bereitzustellen, sondern auch (für Tests) zu klonen oder einfach zurückzusetzen. In allen Fällen ist wird nur der Docker-Container mit der Datenbank und Application Express - und nicht etwa ein ganzes Betriebssystem (mit allen Hintergrundprozessen) gestartet.

Ralf Durben von der ORACLE Deutschland B.V. & Co KG hat in diesem Community Tipp zusammengestellt, wie man ein Docker Image mit der Oracle-Datenbank erstellt und nutzt. Es wird nicht nur darauf eingegangen, wie man die fertigen Oracle-Datenbank Images aus dem Docker Store verwendet, sondern auch, wie man sich selbst sein eigenes, individuelles Docker-Image erzeugen kann.

Dieser Tipp ist ein Muss (nicht nur) für jeden Application Express Entwickler, der hin und wieder eine Entwicklungs- oder Testumgebung aufsetzen muss - gleich reinschauen!

#orclapex Europe tour - 16-Aug-2017 08:17 - Tobias Arnhold
From Tuesday, the 29. of August until the 02. September, I will meet the best experts around Oracle.

But first some background:
Last year I was in Sweden and held a presentation at a meetup in Stockholm about APEX. I met Mathias Magnusson an Oracle specialist who is organizing all kinds of Oracle usergroup events in Sweden. I was lucky to meet him again at DOAG 2017 and introduced him to Joel Kallman. During the discussion came the idea to make an APEX day in Sweden. Mathias prepared everything and invited some well-known experts who may join the party as speakers. In the email, he also was asking Heli Helskyaho. She is one of the world most known speaker about Oracle related technology at the moment.
She liked the idea to join in and asked if we could combine it. One event in Helsinki (Finland) and one in Stockholm (Sweden). And that is not all. Mathias put the date of the event shortly before the POUG in Poland. Conclusion: My Oracle #orclapex Europe tour was set up.
Out of my perspective the Nordic APEX days should look like this: 
We need to show the people what APEX can do and how it is used in production. If an Oracle employee or a consultant is talking about how great the tool is then maybe not everyone will believe it. So, I asked the experts from Deutsche Bahn (SmallSolutions-Team) to join the party and they did!

So, this is what happens now:
    1. Monday I will fly to Helsinki with Richard from Deutsche Bahn. Last preparations with Matthias and Richard (SmallSolutions-Team) for the event.
    1. Having the Oracle/Miracle APEX-Day in Helsinki (Finland): Oracle / Miracle APEX - Day
      1. Including nice talks with Heli, Carsten, Shakeeb and hopefully a lot of APEX interested end users.
    1. After the day we will take the cruiser ship over night to Stockholm including some drinks and talks and "Finnish Tango".
    1. Having the SWEOUG APEX day in Stockholm (Sweden): #SweougApex17
      1. Including nice talks with Patrick, Mathias and hopefully a lot of APEX interested end users. Hopefully a couple of beers in the evening.
    1. Next morning take the plain to Berlin and preparing with Matthias (Small Solutions-Team) for POUG
    1. Meet the students at Berlin main station and take the rented bus to POUG in Kraków.
    1. Getting to know the student group including some activities during the bus trip.
    1. Hotel check-in and dinner with the students
    1. POUG conference starts: #POUG17
      1. Including to meet the best Oracle database experts and get the students to meet them and drink a few beers with Kamil.
    1. POUG Party
    1. POUG conference second day
    1. Evening dinner and taking the bus home
Let me say it in short words:
3 conferences, holding 3 presentations, meeting lots of experts and meeting even more new faces!

In case you are curios and want to get to know the flair from the conferences then follow me at Twitter: @tobias_arnhold / #APEXgoesEurope / #pougtrip / #SewougApex17 / #orclapex

I will write as I have never written before. :)
Atom: Select Variables Faster - 16-Aug-2017 08:06 - Vincent Morneau
Atom: Select Variables Faster

Some languages like HTML and CSS have syntactical standards promoting the use of the hyphen/dash symbol (-).

Let's consider a variable l_my_variable in PL/SQL.
In JavaScript I would name it myVariable.
In CSS I would name it my-variable.

In Atom if you double click on this CSS class, only a part of the class will be selected:

Atom: Select Variables Faster

So you have to manually select the whole thing...

Atom has a setting called Non Word Characters which is definable per language:

Atom: Select Variables Faster

Let's remove the hyphen/dash in there /\()"':,.;<>~!@#$%^&*|+=[]{}?...

Atom: Select Variables Faster

Now when double clicking on the same variable it will select the whole thing:

Atom: Select Variables Faster

It's not much but it's saves me a few clicks.

Can you think of a better use for the Non Word Characters setting?

Apex Plugin: Password Strength Estimator - 16-Aug-2017 00:26 - Jeff Kemp

I needed a simple password strength prompt for users when they need to create or change their password on my website. After a bit of Googling I found the “Low-Budget Password Strength Estimator” which is supposedly used by Dropbox, so you know it’s good :)

This simple javascript library runs entirely within the client’s browser, and when presented with a candidate password, gives a score from 0 (very poor) to 4 (very good). It can also return extra feedback, including a warning message for poor passwords, as well as suggestions for making a password more secure.


So I’ve created a very simple Dynamic Action plugin (try the demo here) that allows you to add this functionality to any item on your page. You can specify a minimum length for the password, and can override the default messages for each score. You can also select whether or not the feedback warnings or suggestions are shown.


It seems to catch a lot of poor passwords, including ones comprising common words and names, and ones involving a simple sequence or repetition.



Obviously it’s only really useful for password entry fields; but don’t use it on your Login page!

Download from:

Filed under: APEX, Oracle Tagged: APEX, passwords, plug-ins
Storage Server: datasets, snapshots and performance - 15-Aug-2017 14:47 - Frank van Bortel
Datasets, snapshots and performance This is a long post, but with lots of pictures. Kind of a management overview ;) Datasets and snapshots Datasets As may have become clear from a previous post, I have one volume, with a (a -to date- single) dataset (ds1). This was not the result of experience, or deep thought, it was just copied from Benjamin Bryan who did an entry on ZFS hierarchy. Makes
En el presente artículo quiero compartir con toda la comunidad las entrevistas que llevé a cabo a dos colegas amigos Mónica Godoy y Daniel Bozzolo junto con mi experiencia siendo desarrolladora.
Nuestro objetivo, principalmente es motivar a la juventud y a aquellos que quieran incursionar en el mundo del desarrollo, a tener una visión de lo que fue para cada uno de nosotros llegar a convertirnos en desarrolladores.
Para ello vamos a contestar las siguientes preguntas:
  • ¿Quién o qué influyó en tu vida para llegar a ser un desarrollador?
  • ¿Cuáles serían para ti los primeros pasos a seguir para convertirse en uno?
  • ¿Qué consejos darías para alguien que quiere iniciarse en este camino?
Seguir leyendo AQUI