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):
The APEX page apexcompetition.org
was developed using two pages.
One for the German speaking community and one for the English speaking APEX developers.
Normally you would create an application and translate the text parts after you finished the development. With apexcompetition.org we developed a one page application. Instead of translating the page we decided to create a copy of the page and translate this one instead. In the end we had one for (more...)
APEX Dashboard Competition
initiated by Tobias Arnhold
is now online. If you want to compete against your colleagues all you need to do is to create a nice looking dashboard based on the prepared set of data, crate a packaged application and send it to the jury. You can apply here: Submit your application
and win some nice prices. Hurry up. The closing is on Friday the 1st of April 2016.
Liebe APEX Community,
ich bin froh nun endlich die nächste große Sache präsentieren zu können. Wir veranstalten eine APEX Competition nach dem Vorbild der APEX Gaming Competition
Erschafft eine APEX Dashboard Anwendung. Kurz zusammengefasst:
Erstellt bis zum 01.04.2016
eine APEX Universal Theme Anwendung
mit einer Seite
die auf Basis eines vorgefertigten Sets von Daten,
die ultimative Dashboard
Erfahrung liefert.Was bringt euch die Teilnahme?
Es gibt geniale Preise vom ersten bis zum zehnten (more...)
I have to import a set of XML files from time to time. Most of those XML files can be imported with out any problems. But at least one file includes a special character U+0016 which occurs randomly some where inside the file.
When I try to import that file I get this ORA- error message:ORA-31011: XML-Parsing nicht erfolgreichORA-19202: Fehler bei XML-VerarbeitungLPX-00217: Ungültiges Zeichen 22 (U+0016)Error at line 39409 aufgetretenMehr »