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...)
I’m trying to write this blog post with classeur.io.
Just like Martin I’m also searching for alternative ways to write blog posts. I don’t want to completely migrate my blog to a new platform, so I’m searching for a way to write in Markdown and deploy to Blogger.
Since our development of APEX Office Print (AOP) we also use Markdown for our documentation as it makes including code samples easier, it can (more...)
Yesterday APEX 5.1 (5.1.0.00.43) was installed on apex.oracle.com
This means that you can start developing your apps in APEX 5.1 from now on. Unlike the early adopter releases (apexea.oracle.com
) you can develop your apps on apex.oracle.com
and later export them and import in your own environment once the on-premise version of APEX 5.1 is available.
APEX 5.1 is again (more...)
If you're following some Oracle blogs or Twitter, you'll see many blog posts starting with "OTN Appreciation Day : " today. You can read the story behind this initiative on Tim Hall's blog. "The blog post content should be short, focusing more on why you like the feature, rather than technical content."
In my life Oracle played (and is still playing) an important role... and it all started because I love working with (more...)
In my previous post
The installation of SQLcl
is easy... you just download the zip
, unpack and run the executable.
But to be fair, before I got SQLcl running (especially the script part) I encountered a number of issues, so hopefully this post helps you be able to run SQLcl with all features in minutes as it's meant to (more...)
In the last two years I've been using JSON in almost every project I was involved in.
For example with APEX Office Print
our plugin is sending JSON to the backend. This JSON you can actually see yourself in the Remote Debug screen in your AOP Dashboard
Another example is the wearables project (IoT) I showed at KScope 16
; the wearable is sending data to a smartphone or tablet, which in his turn is (more...)
Interactive Reports (and Grids in 5.1) are one of the nicest features of Oracle Application Express (APEX) as it allows an end-user to look at the data the way they want, without needing a developer to change the underlying code. End-users can show or hide columns, do calculations on columns, filter etc.
Here's an example of an interactive report where highlighting, computation and aggregation is used.
More than once I get the question, how (more...)
A few days ago I got an email about an experiment how to program with the crowd.
I didn't really heard about it before, but found it an interesting thought. In this experiment people will perform microtasks (10 minutes task), as a member of the crowd. People don't know each other, but will collaborate together. The system is distributing the work and supplies instructions. The challenge is in creating quality code that meets the specifications.
Why use HTTPS?
When you Google this question you get many different answers, but this
answer of Google Developers answers it for me in short (click the link for more details):
- HTTPS protects the integrity of your website/APEX app
- HTTPS protects the privacy and security of your users
- HTTPS is the future of the web; many new technologies only work with https (for example Service Workers; you can read more about Service Workers and APEX (more...)
How did you get started with developing your first APEX app?
My guess is either you went to https://apex.oracle.com
and got a free account or Oracle Application Express was already in your company and somebody told you the url you could connect to. For me that is really the power of APEX, you just go to an url and within minutes you created your first app.Staying within the APEX framework?
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):
Only 3 days left to submit your abstract for KScope 16... so don't wait longer, submit
My first ODTUG conference was in 2006 and it was awesome. On this blog you'll find different blog posts about my experience and why I love it, so I won't go over that... but from time to time I get some questions about being a presenter at the event."What should I submit, I don't know what (more...)
In 2008 I blogged
about how to add Group Headings into an Interactive Report in Oracle Application Express (APEX 3.x!).
Here's an example what I mean with Group Headings, you want to logically group certain columns (e.g. Empno, Ename) and have a group name above them (e.g. Group 1):
The approach I used at that time worked, but it required a lot of manual work. In 2009 Martin D'Souza improved it (more...)
In a comment on my post APEX 5.0: pimping the Login page
I got a question how to put your own logo or a custom image on the login page, instead of an icon.
You only need a bit of CSS to do the trick:
You can add the above CSS to your login page - Inline CSS in page attributes or you can add it to your page template or custom CSS in (more...)
On September 13th I got a nice surprise, an email of Steven Feuerstein with the message: "You have been selected as a finalist in the ORDS category for the 2015 Oracle Database Developer Choice Awards
It's always nice to get recognition for the efforts you do, so thanks so much already for the nomination. I didn't make publicity yet in order to get some up-votes, but I hope by reaching out to the people (more...)
The Universal Theme in APEX 5.0 is full of nice things.
When you add a region to your page with a couple of sub-regions and you give the parent region the "Carousel Container" template it turns the regions into a carousel, so you can flip between regions.
I was asked to have the same functionality but than on dynamic content.