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 »
Is Oracle Application Express
secure? That's the question I received today, from the customer of a partner. The customer asked:
"Do you know if Oracle or a third-party has verified how secure APEX is against threats or vulnerabilities? It would be nice to have something published saying how secure APEX is and how it’s never been compromised."
Now I imagine smart people like David Litchfield
or Pete Finnigan
or Alexander Kornbrust
would hope that (more...)
Some of you may know the plugin "UILayout for APEX
" I developed in 2011. It is based on the jQuery plugin called "UI Layout
I'm currently develop a new version running only inside the Universal Theme (UT). This version is completely redesigned and focused only to work with the UT.
Actually it is quite cool because it supports some really handy features:Mehr »
In this blog post I will provide news, questions and problems about the dashboard competition which were published by Twitter.
You can follow Twitter yourself searching for this hash tag: #apexcompetition
Providing file upload and download capabilities has been native functionality in APEX for a couple major releases now. In 5.0, it's even more streamlined and 100% declarative.
In the interest of saving screen real estate, I wanted to represent the download link in an IR with an icon - specifically fa-download. This is a simple task to achieve - edit the column and set the Download Text to this:
<i class="fa fa-lg fa-download"></i>
With the ever-changing browser landscape, we needed to make some tough decisions as to which browsers and versions are going to be deemed "supported" for Oracle Application Express
. There isn't enough time and money to support all browsers and all versions, each with different bugs and varying levels of support of standards
A position that's been adopted for the Oracle Cloud
services and products is to support the current version of a browser and (more...)
Last year I blogged about highlighting negative numbers in an APEX Report
, the CSS only way.
At that time I gave two alternative approaches; by using JQuery or SQL, but it looks like I didn't do those posts yet, till somebody reminded me. This post is about using SQL to highlight something in a report.
Let's say we want to highlight negative numbers in a report (as in the previous post):