The Interactive Report has this great download feature where you can export everything you can see.
Anyway there are circumstances where the customer doesn't want that feature open for everyone.
In APEX you can only choose if you want the download button or not.
Even so APEX can't do it out of the box. There is a way to make your application able to do it.
Since APEX 5 you can't download when the "Download" (more...)
While education in Oracle Application Express (APEX)
is offered as a part of many university and secondary school courses around the globe, in most cases, the educators took it upon themselves to develop their own custom curriculum. To lessen the burden on educators, we have developed and made available for public download a full course curriculum for Oracle Application Express.
This courseware, developed by our product manager Chaitanya Koratamaddi
over the past year, includes 16 (more...)
Yesterday I put a question on twitter, to find out what others prefer: table names using singular or plural form. I expected one or two replies, not an avalanche :-)
As expected there were all kind of replies going either singular or plural. Some (more...)
Many of you are still using the old "Component View" but the "Page Designer" introduced in APEX 5 made the developer life much easier.
The top 5 most time saving abilities for me are:
1. Easy access on all page elements (without any page refresh)
2. Copy&Paste of items, regions, dynamic actions, ...
3. Drag&Drop moving of items and regions
4. Multi edit of items
5. Since APEX 5.1: The ability to customize your (more...)
Last week the SS Rotterdam was the beautiful location of the largest gathering of APEX Developers worldwide. With around 380 (!) attendees a new high was set. And they came from all over the world : I spotted people from The Netherlands, Belgium, Switzerland, Austria, Croatia, Germany, Denmark, Norway, UK, Ireland and the USA. And I even might have missed one or two ….
The event started with a presentation by the “father of APEX”, Mike (more...)
Yesterday a first patch set
of Oracle Application Express (APEX
) 5.1 has been made available to download
If you encounter issues, you can ask for support and most likely a bit later a patch is made available through support.oracle.com. The APEX team is doing a great job with this.
Just in time for APEX World 2017
, Oracle Application Express 5.1.1 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.1.1, you can get it from the Downloads page
on OTN. If you have Oracle Application Express 5.1 already installed, then you need to download the APEX 5.1.1 patch set from My Oracle Support
. Look up patch (more...)
A lot of you are using jQuery to customize visual parts of an APEX application. I probably to often do so myself but there is a much more elegant way: CSS
Nowadays you are able to add different kind of rules into your CSS styles. In this example I will show you how to get into the topic by changing an Interactive Report (IR). In my example I want to change the typical group by (more...)
Unless you've managed to somehow filter out everything about US politics over the last few months (and if you have, please let me know your secret), then you've likely heard about "fake news". From a high level, my basic understanding of "fake news" is that it refers to stories or websites that are fabricated to advance the political beliefs and/or ideologies of one site or the other. Your definition may differ.
So what is fake (more...)
So what are my experiences using EECS doing some APEX work?
First of all, it is not blazing fast. Probably caused by the latency (as mentioned in my previous post). It is not slow, it is just ok('ish).
Second, and way more important, it runs APEX 5.0.4
! So whatever Oracle advertises about "Cloud first
" ... it doesn't seem to apply to APEX (or APEX on EECS). So this fact alone makes (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.
This year, I've got three slots, each as different as the next:
NATCAP OUG - or the National Capitol Region Oracle Users Group - has a long history of providing Oracle-related content to those in the DC metro area. I remember presenting there back in my Oracle days (early 2000's) on multiple occasions.
Over the last few months, a few of us have been trying to resurrect this group, as there are likely more Oracle developers & DBAs in the DC area than any other area in (more...)
Execute a "Dynamic Action" by clicking on a button/link inside a report row is mostly handled by some triggering HTML class.
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...)
APEX 5.1 ist endlich da. Oracle Application Express wird mit jedem Release besser und zieht immer mehr Entwickler weltweit in seinen Bann. Es ist einfach, einfache wie auch komplexe Applikationen auf Basis des Oracle Stacks zu entwickeln. Es macht sogar richtig Spaß !
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...)