So what is fake (more...)
So what is fake (more...)
Alright, stop! Collaborate and listen! Ok, I’ll be the one to take my own advice here and stop...
Later this month, I’ll be heading to Reykjavík, Iceland to deliver our 3-day training class “Developing Desktop APEX Applications”. This class will be open to the public and costs about $2500 per student, so anyone is welcome to sign up. You’ll have to make your way to Iceland, of course.
Here’s a brief overview of what we’re going (more...)
This Thursday, I’ll be participating in the Taste of KScope 2017 webinar series by presenting GET POST ORDS JSON: Web Services for APEX Decoded. The webinar will begin at noon EDT on Thursday, March 16th. The webinar is completely free, and you don’t need to be an ODTUG member to attend.
Here’s a summary of the abstract:
Web Services in the APEX world are becoming more and more popular. However, there is still a lot of (more...)
Recently, there has been a lot of buzz about "low code" development platforms. Even the Oracle APEX team has embraced this term (see https://apex.oracle.com/lowcode/ for details). This approach allows the "citizen developer" - someone without a traditional IT background - to build basic applications with little to no code. Platforms such as QuickBase, Appian, Mendix and even SalesForce.com have popup up, offering the promise to quickly build applications with little to no (more...)
It's going to be a hectic couple of weeks for me, as I get ready to head to Utah this weekend for the annual UTOUG Training Days conference next week. I love Salt Lake City, and the UTOUG conference is just the right size - not too large, but large enough that most of the rooms are full of attendees.
It actually works in 95% of all cases. But it is not the best way to do it. It is much more effective to execute the "Dynamic Action" with a custom event.
Reason is simple: You don't need to allocate unnecessary elements via a class by jQuery. You execute the "Dynamic Action" in the (more...)
Mit APEX 5.1 sind als wichtiges neues Feature die Interactive Grids mit dazu gekommen. Wir haben sehr lange auf eine moderne Möglichkeit gewartet, Excel - ähnliche Funktionen auf einer Webseite mit (more...)
APEX 5 introduces native dialogs, both modal and non-modal. This article discusses:
- How to enable dialogs in your APEX 5 application if they are not already enabled.
- How to open a dialog.
- How to close a dialog, returning values from that dialog.
- How to respond to the closing of a dialog.
How to enable dialogs in your APEX 5+ application if they are not already enabled.
To check if Dialogs are already usable within your (more...)
When you have a classic report in Oracle Application Express (APEX) and want to make it searchable you typically add a Text Item in the region, enable Submit on Enter and add a WHERE clause to your SQL statement.
Here’s an example:
Your SQL statement probably looks like this:
where CUSTOMER_ID = :P4_SEARCH
When you want to search for multiple customers separated by (more...)
When reviewing Oracle APEX applications I often see hardcoded date or timestamp formats.
You can define your date formats in multiple places in your application. In your item or column attributes, as part of your code e.g.TO_CHAR(sysdate, ‘DD-MON-YYYY HH24:MI’) or if you want to make it more reusable you might create a substitution string. That will all work, but you can make your life easier and for the ones looking or needing to (more...)
Today I got the question how to change the label of an item in Oracle Application Express (APEX) based on some condition. I actually had this requirement myself a couple of times, so maybe other people too.
Here’s an example; whenever we change the Source item, we want the Affected Item to change it’s label:
The first thing that comes to mind (if you already know a little bit of APEX); lets use a Dynamic (more...)
IntroductionWhen Oracle Multitenant was released with Oracle Database 220.127.116.11.0 in June 2013, Oracle Application Express was installed by default common in the CDB in CDB$ROOT, PDB$SEED, and all PDBs. In fact, that was the architecture that we recommended at that time. As we have gained experience with multitenant in our internal deployments, we realized that our initial recommendation was wrong. Having APEX installed common locks you in to one version (more...)
The Oracle Database ships with a wonderful technology called Oracle Text. Most people associate Oracle Text with the mere ability to index documents or data, perform text or phrase queries and get the results back. But Oracle Text can do so much more. One of the more interesting features of Oracle Text is the ability to analyze a document and generate a list of themes for the document along with a weight associated with that theme.
In Oracle Application Express, unexpected exceptions can occasionally occur. Instead of communicating the technical details to an end user who is running the application, an error message will be issued of the form:
Contact your administrator. Details about this incident are available via debug id "NN".
But what actually happened? Who is "your administrator"? And what exactly are you supposed to do with this information?