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:
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.
Today, I observed an exchange inside of Oracle about a topic that comes up from time to time. And it has to do with the development of APEX applications, and how you manage this across releases and a larger number of developers. This topic tends to vex some teams when they start working with Oracle Application Express on broader development projects, especially when people are not accustomed to a hosted declarative development model.
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):
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 erfolgreich ORA-19202: Fehler bei XML-Verarbeitung