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.
During my holiday Apress released the second edition of Expert Oracle Application Express.
In the second edition we not only updated the content to APEX 5.0, but there're some new chapters in too from new authors. In total you get 14 chapters from 14 different authors.
I believe it's a very nice book with great content and it's for a good cause. Roel describes it very nicely in his blog post
"the goal (more...)
I know some people waiting till the first patch set that comes available after a major Oracle APEX release... today you no longer have to wait, APEX 5.0.1 is now available.
In the patch set notes
you can read what changed.
If you're still on APEX 4.x you can go immediately to APEX 5.0.1, you only need to download
the latest version on OTN.
If you're already on APEX 5. (more...)
APEX 5.0 has been released this spring. People who have already spent some time on this new version know this version is packed with new features aimed to make APEX developers even more productive, like the Page Designer.
Another striking new subset of features is aimed at creating better looking user interfaces for your APEX applications in an easy and maintainable way.
The definition of user interface components in APEX 5.0 is (more...)
When you migrate to APEX 5.0 and the Universal Theme you might see that some plugins are not behaving correctly anymore. In this post I'll discuss the Enkitec Modal LOV
When I ran the plugin in my APEX 5.0 app with the Universal Theme it looked like this:
There's too much space in the search bar and the close button is not showing up with an icon.
Here're the steps I did (more...)
On Monday Bob Rhubart did a video call with me in his series of 2MTT
(2 Minute Tech Tip) on YouTube. You find my 2MMT here
I talked about using JSON and APEX and gave two examples were we use it.
In previous blog posts I gave more details on those techniques. Here's a quick overview:
comes with a new calendar region, which is way nicer than the previous calendar in APEX. It has more features, looks better and is also responsive. Behind the scenes you'll see the calendar region is based on Full Calendar
In Belgium we use Monday as first day of the week, whereas in the US they seem to use Sunday as start of the week in the calendar overview. I've been integrating Full (more...)
In previous blog posts I talked about JSON for APEX Developers:
In this post I want to show how you store and query JSON data straight in the database.
To start, create a table to store the JSON object:
CREATE TABLE ssn_json
(id NUMBER GENERATED ALWAYS AS IDENTITY NOT NULL,
After 2.5 years of development, today is the day APEX 5.0 is publicly released and ready to be downloaded
to install on your own environment.
In my view it's the best release ever. Not so much of the new Page Designer - although that is definitely a piece of art and it increased productivity even further - but because it's the first time whole of APEX got refreshed and every piece was put (more...)
Ever tried to put multiple Trees on the same page in APEX 4.2?
Here's my example:
On the left Tree the "Selected Node Link with" is set to hidden item P1_TREE1, on the right Tree the value that sets the tree is set to P1_TREE2. At least it should do that, but by default if you're values are not unique - in this case empno is the value behind both trees - it doesn't (more...)
When you create a new application in APEX 5.0, the login page probably looks like this:
I love the build-in login page of APEX itself - luckily it's easy enough to build that in our own apps too. Thank you APEX Dev team!
The first step is to change the region type to be of Login Region Template:
We want to add a nice icon on top of the Login text. You can use (more...)
I often need to load the data of Excel or CSV files into the Oracle Database.
Ever got those annoying question marks when you try to load the data? or instead of question marks you just get empty blanks when the file is using special characters? Here's an example:
My database characterset is UTF-8, so ideally you want to load your data UTF-8 encoded.
With Excel I've not found an easy way to specify the (more...)
Today Oracle released new versions of:
You may want to check Kris Rice's
blog for new features.
I already blogged about all of the tools before, but not yet about SQLcl.
This is a command line tool, I call it "SQL*Plus on steroids" (or as Jeff calls (more...)