A minor but important change is happening for Oracle Application Express
in the forthcoming Oracle Database
12cR2. Specifically, Oracle Application Express will not
be installed by default in the Oracle Database. This change was made specifically at our request. We thought the pros far outweighed the cons, and we thought this was good for our customers and consistent with our recommendations.
- Provides flexibility for a DBA to run multiple APEX versions in an Oracle (more...)
If you experience a problem accessing My Demo Application (old and new version)
at apex.oracle.com, that means there is a reason for that. One of the users deleted all the applications in my workspace and installed some of his own. I don't think this was intended but it is still a lot of work and I am trying to geta all the important stuff back online. After that I will need to rethink (more...)
Just a quick note: I’ll be holding a 1-day APEX training class on April 21st in Vienna, Austria.
In this training I’ll teach you how to debug your APEX applications, how to find problems and bugs and how to speed up your application.
Interested? Go here and sign up: http://www.aoug.at/Event/413
In the last post I showed how you can upload a custom theme to the instance repository so that all your developers can choose that theme within the create application wizard. And more importantly, subscribe that theme from the theme repository.
Now the next question is how to update that public theme so that all applications can inherit the changes.
My first attempt was to simply go to Instance Administration – Manage Instance – Public (more...)
The Universal Theme introduced with APEX 5 is immensly good looking and comes with a powerful Theme Roller to customize it.
With that new theme most, if not all, older themes are obsolete.
That leaves us just with a few corporate designs which can’t (or don’t want to) be replaced by the UT.
Now ideally you want your developers to use that custom theme in all applications and also subscribe to that.
Historically I recommended (more...)
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 »