Conference Season

It's conference season!  That means time to start looking at flights and hotels and ensuring that while I'm on the road, my wife is not at work (no easy task).  In addition to many of the conferences that I've been presenting at for years, I have a couple of new additions to the list.

Here it is:

RMOUG - Denver, CO
One of the larger conferences, the year usually starts out in Denver for me, (more...)

Autologin for demonstration applications

Why would you need an "auto login"? Can't it be configured in APEX?
In APEX you have a setting to configure the maximum session length. But this setting only lasts a certain time (12 hours as most).

The setting can be found under Supporting Objects > Security Attributes > Session Management:



But in some use cases you don't want the application to log out and to manually re-login again.

An "auto login" can come in (more...)

If you’re new to the APEX community, here are some tips to get engaged

Last night (January 6, 2016) we had our first-in-2016 APEX Meetup meeting in Columbus, Ohio, USA.  For being on short notice, we had a nice turnout, and I was able to distribute the new apex.world stickers.  I was most impressed that a gentleman (by the name of Shannon) drove down from Cleveland, Ohio - almost 2 hours drive each way.  He's been using APEX for all of two weeks, was using it with (more...)

APEX Entwickler gesucht…

Die Deutsche Bahn ist auf der Suche nach einem APEX Entwickler.

Aktuell bin ich durch meine selbstständige Tätigkeit selbst vor Ort und meine Eindrücke möchte ich mal nach außen tragen, damit ihr seht wie die Bahn auch sein kann.

Mich persönlich beeindrucken nicht die offensichtlichen Dinge vor Ort:
 - Die Stadt: Frankfurt
 - Die Firma: DB Systel (IT Dienstleister der Deutschen Bahn)
 - Der Tower: Dein Arbeitsplatz ist an einer der höchsten Stellen in Deutschland
(more...)

A Few Resolutions for 2016



Jenny, from the Oracle Database Insider Newsletter, asked a number of us in the Database division at Oracle to share our New Year's resolutions for 2016.  And while I'm a bit reluctant to share this somewhat personal information, I like the fact that publicizing these resolutions may force me to remain a bit more focused on these goals.  So here goes...my resolutions for 2016:


  1. Attend an Oracle Real World Performance Training class. (more...)

Remove Blanks from Formated Date Column

This small example is showing how powerful jQuery is and how easy it is to use it in APEX. In this case, I needed to correct the oracle formatting, which adds blanks to the name of the day prior to comma. Probably oracle RPAD's the day names to the longest (Wednesday). Those are showing in APEX as one blank - see the left column. The only good way to go around that annoying side (more...)

Das war 2015 und nun?

In meinem letzten Blogpost für dieses Jahr, möchte ich noch einmal kurz auf alle Highlights in 2015 eingehen. Ich wünsche viel Spaß beim Revue passieren lassen! :)

APEX CONNECT 2016 und das HH24:MI Dilemma

Als ich das Vortragsprogramm der APEX CONNECT 2016 gelesen habe, musste ich mich doch kurz wundern...
Mehr »

APEX 5 Migration – Part 2 – Common application issues after the migration

This time I will tell you more about the most common problems in your APEX applications after an upgrade to APEX 5.

You will find the most migration bugs in following situations:

Generierung von Bitlisten mit Hilfe von SQL am Beispiel einer Datum zu Monat Konvertierung

Ich hatte vor kurzem die Aufgabe erhalten eine Bitliste auf Basis eines Monats zu generieren.
Bedeutet, ich habe einen String mit 31 Zeichen der je Zeichen den Zustand 1 oder 0 einnehmen kann.
 - 1 steht für aktiv
 - 0 steht für inaktiv

Beispieldaten:
'0000000001010001000000000000000'
'0000000000000000111111000011010'

Um dies anhand eines verständlichen Beispiels zu verifizieren, habe ich mir eine Dienstplan-Tabelle ausgedacht.
Mehr »

APEX 5 Migration – Part 1 – Requirements and Installation

During this year I have done several APEX 5 migrations and I held three lectures on the topic.
Unfortunately it only reached out in Germany, however the content would contribute to simplifying the work for everyone. So I decided to blog it. I will cover this topic in three different posts:
- Requirements and Installation
- Common issues after the migration
- Universal Theme migration

I start with the requirements and installation of APEX 5.
(more...)

APEX Feature Request

Just created a new feature request for APEX at https://apex.oracle.com/pls/apex/f?p=55447:19:::NO:19:P19_ID:50481528500531591330407043519019274105 … Extend Interactive Report API - Get IR Query. The feature request is abut the following:

"This API should deliver a couple of different SQL statements for an interactive report. There are several possible requirements I can think of:

1. IR query including visible columns and filter values - actual SQL for the user session,
2. IR query including all columns and (more...)

I Had Low Expectations for the APEX Gaming Competition 2015 from ODTUG. Wow, Was I Ever Wrong!



When the APEX Gaming Competition 2015 was announced by Vincent Morneau from Insum at the ODTUG Kscope15 conference this past year, I was very suspect.  I've seen many contests over the years that always seemed to have very few participants, and only one or two people would really put forth effort.  Why would this "Gaming Competition" be any different?  Who has time for games, right?  Well...I could not have been more wrong.

I was (more...)

Presentation slides for my presentation at DOAG 2015 – Apache – ORDS Setup for Production Environments

Hi guys,

here you can find the slide, the config files and installation steps for my presentation at the DOAG conference in Nürnberg on 18.11.2015:

http://www.opal-consulting.de/downloads/presentations/2015-11-DOAG-ORDS-Setup/

Enjoy!

Cheers,
~Dietmar.

Oracle JET Charts – Do we need alternatives anymore?

After I looked through the chart types supported by the new Oracle JET framework I asked myself if we need other chart plugins like D3JS or RaphaelJS in future APEX releases anymore?

The answer is: Yes in special cases.

My supposition is that we can use all available JET charts in one of the next versions of Oracle APEX.

Now I will describe the "special case" with two examples where other chart frameworks still make sense:
Mehr »

Refreshing PL/SQL Regions in APEX

If you've been using APEX long enough, you've probably used a PL/SQL Region to render some sort of HTML that the APEX built-in components simply can't handle. Perhaps a complex chart or region that has a lot of custom content and/or layout. While best practices may be to use an APEX component, or if not, build a plugin, we all know that sometimes reality doesn't give us that kind of time or flexibility.

While the (more...)

APEX 5 Cheat Sheet

On Twitter today, Jeff Smith tweeted about a new SQL Developer cheat sheet that he created with a site called cheatography.com.

Not to be outdone, I created a cheat sheet for the APEX 5 Keyboard Shortcuts. Not only can you view it online, but you can also download a PDF version of it. Check it out and let me know if there's anything that you'd like to see added.

I *almost* made it to the ODTUG Board of Directors …

Last month was the annual election for the Board of Directors of ODTUG. And just like the year before, I was one of the 19 (!) candidates for one of the 5 spots. 
During the campaign and election periods I received a lot of positive feedback and my hopes were high - but the competition was extremely strong. During Oracle Open World the results were announced and I was notified I hadn't made (more...)

All JET charts in APEX 5.1

I added a new feature request for APEX:
APEX 5.1 with support for all available JET Data Visualizations Charts

Description:
APEX 5.1 will include a new charting engine based on the new Javascript Framework "Oracle JET". Unfortunately APEX 5.1 will only include those charts from the JET website (http://www.oracle.com/webfolder/technetwork/jet/uiComponents-dataVisualizations.html) which are supported in the current version of APEX. For example the "Spark Chart" or the "Timeline" will (more...)

SQL: Calculate the past time between two dates in percent

Just a simple example how easy APEX can handle this kind of problem.

Example:
We have today the 06.11.2015 (11-06-2015) and we have two date values 01.11.2015 and 30.11.2015.
Now I want to know how much time has past in percent since the beginning (01.11.2015):
Result: 17 %
Mehr »