This afternoon my Twitter timeline exploded with retweets, likes and congratulations. It all started with this tweet:
So it's official now. As Sarah Zumbrum had to step down due to her (dream) move to Oracle, a position on the ODTUG board opened up. And I was asked whether I was still interested. And of course I was! So after an internal voting procedure, I received the good news last weekend - and had to keep (more...)
I just came back from the apex.world conference in Rotterdam
... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure.
As promised, you can download the slides and the demo script (as is) from my site
Instructions are included.
See you at APEX Connect in Berlin or KScope in Chicago, #letswreckthistogether .
Cheers and enyoy!
Today I will show a code example how you can add browser recognition inside the "Inline CSS" mask of your APEX page.Mehr »
In this blog post
from 2015 I explained how to open a modal window from an item and pass the values back, display a sucess message, etc. This page also contains an item plugin to make it easier to do the whole stuff and avoid hardcoding. I have never published this plugin. Hopefully this functionality is going to be a standard part of 5.1. Now, I was asked to make this working with a (more...)
Maybe this an old hat but a lot of people don't know how to use and analyze APEX_COLLECTION properly. For myself it is a good reminder and saves me about 2 minutes instead of googling around.
In this example I will show you how to
- create an APEX_COLLECTION
- select the data in APEX reports
- analyze APEX_COLLECTION in SQL Developer
I will only show some basic steps. For a more detailed explanation (more...)
See this example
on how to change the item position. In APEX you can position the buttons after the action bar in an interactive report. However, you can't put the items there. Using jQuery this is easy to achieve.
See this example
on how to react on tab change in APEX 5. The problem is to determine the right selector to trigger the corresponding dynamic action. Thanks Christian Rokitta
for your help.
In den letzten Tagen wurden mir mehrere Fragen rund um die APEX Dashboard Competition
gestellt. Die Fragen und Antworten möchte ich gerne teilen:
In wieweit darf man das Universal Theme verändern? Darf die Anordnung der Regions geändert werden? Darf das Menü links entfernt werden?
Sie können mit dem Universal Theme machen was Sie wollen.
Einzige Einschränkung: Das Theme sollte nicht unter einer anderen ID abgespeichert werden. Dann wäre es ein Custom Theme und (more...)
A customer of mine switched to a Singe Sign On Authentication Scheme for their APEX application - using Oracle Access Manager, but that's irrelevant to this case.
Are you in Vienna/Austria on February 25th 2016 and interested in APEX?
Then you have to come and join us at the “APEX in the Cloud Day” – reserve your seat right away!
Today I had to suffer on a real APEX 5 bug.
When you upload a file the NLS settings in your current APEX session will be set to AMERICAN.
I check for issues like that and found a forum post where someone else was experiencing the same problems as I did:File browse changes some NLS settings - possible bug
My purpose was to upload a CSV file and transforming it to table data. Now (more...)
The renewed Calendar Region in APEX is awesome. With just one SQL statement you can provide your users with a calendar view of their data that looks very familiar to what they already know, use and love. Apart from one thing: Navigating to a specific date is cumbersome.
The shortest route is:
- Navigate to the right month (can be any number of clicks)
- Switch to "Week view"
- Navigate to the right week (between 0 and (more...)
Im heutigen Beispiel möchte ich einmal kurz aufzeigen, wie Sie einen Text nach Ihren Bedürfnissen hin normieren können. Ich habe dazu die bekanntesten Länder der Erde in einer WITH Clause zusammengefasst und bilde mir anhand des Namens einen später verwendbaren normierten String.
Der Zielstring muss GROSSGESCHRIEBEN sein und darf keine Umlaute (ÖÜÄöüäß) und Sonderzeichen (, '.()-) beinhalten.Mehr »
Oracle hat zusammen mit der DOAG das Webinar "Modern Application Development
" organisiert, darin habe ich auch ein Webinar (auf deutsch) zum Thema "Oracle als REST-Service mit ORDS – So geht‘s" beigesteuert.Die Folien dazu findet Ihr hier.
In one application I had the requirement to set up a shuttle item to be half readonly. All you should do was to add new values from the left to the right side. You should not be allowed to remove values from the right side.
The result should look like that:Mehr »
Seems to be a simple problem and easy to fix. Actually it is not because if you try one of these examples then you will fail: Mehr »
As a lot of people know, apex.oracle.com
is the customer evaluation instance of Oracle Application Express
(APEX). It's a place where anyone on the planet can sign up for a workspace and "kick the tires" of APEX. After a brief signup process, in a matter of minutes you have access to a slice of an Oracle Database
, Oracle REST Data Services
, and Oracle Application Express, all easily accessed through your Web (more...)
Above you see an example of an Interactive Report everyone should know: this is the Application Builder listing all pages of an application.
The task at hand is to call (more...)
Ever since APEX 5, the poor Navigation Bar has taken a back seat to the Navigation Menu. And for good reason, as the Navigation Menu offers a much more intuitive and flexible way to provide site-wide navigation that looks great, is responsive and just plain works. However, the Navigation Bar can and does still serve a purpose. Most application still use it to display the Logout link and perhaps the name of the currently signed (more...)
Im heutigen Blogpost möchte ich kurz anhand eines Beispiels aufzeigen, wie Sie die Entfernung von SDO_GEOMTRY Punkten berechnen können. Hierbei gehe ich auch konkret auf das Problem des Verbindens von zwei Datenmengen anhand einer definierten Entfernung ein.Mehr »