APEX 5.0: Plug-In Attribute Enhancements

In Oracle APEX 5.0 we have added several new features to Custom Plug-in Attributes to improve the usability of your Plug-ins when they are used by other developers. Show in Wizard Some Plug-ins do make use of the maximum number of 25 … Continue reading

APEX CONNECT: Noch 59 Tage (1.428 Stunden)

Die APEX CONNECT rückt immer näher.

Viele Vortragende erstellen ihre Vorträge immer kurz vor knapp. Da ich aufgehört habe APEX mit Hilfe von PowerPoint zu präsentieren, muss ich jetzt schon loslegen um Stück für Stück die optimale Präsentations-Beispiel-Anwendung aufzubauen.

Meine Präsentation wird sich um die maßgerechte Verwendung von APEX Plug-Ins drehen.
Details zum Vortrag:

Ziel ist es, einen realistischen Blick auf Plug-Ins zu vermitteln und Ihnen die atemberaubenden Möglichkeiten, aber auch die Gefahren anhand von (more...)

APEX 5.0: Declarative Definition of CSS and JavaScript Files to Load for a Plug-in

A best practice for performant HTML pages is to load CSS files in the HTML head to reduce redrawing of the page when a CSS file gets loaded. But because the PL/SQL code of a Plug-in isn’t executed util a … Continue reading

Slides from my presentation at APEX World 2015 in Rotterdam

Hi guys,

I had a great time at APEX World in Rotterdam, it was a wonderful event. I could meet up with my friends and learn a few new tricks, too :).

Here are the slides from my presentation about the many smaller new features of Oracle APEX 5.0. And I could only cram like half of the good stuff that I found into this 45 min. session.

About 70 people attended the (more...)

Oracle Database Development Tools (ODDT) 2015-03-23 19:41:00

If you haven't done so checkout the Oracle APEX universal theme packaged application on apex.oracle.com.  Here it is from inside a Tesla on a crisp 17" touchscreen.  Yes it does work while driving.

apex.oracle.com – Upgrade to APEX 5.0

It is time to get used to the new APEX builder interface. apex.oracle.com has been upgraded to the latest pre-production version of APEX 5.0. Some functionality like "Administration" are not visible any more and you have to search a bit. The overall impression is good and my old demo application seem to still work in the most of the cases.


apex.oracle.com has been upgraded to a pre-production version of Oracle APEX 5.0

If your an Oracle APEX developer you will want to try http://apex.oracle.com.  We have just upgraded this free service to a close (but not yet) production version of Oracle APEX 5.0.  If you already use apex.oracle.com login and validate your applications work as before.  If you don't have an account create one; it should take less then a minute.

Oracle APEX 5 has a new feature called "Universal Theme".  A (more...)

Read Only Item Layout

The possibility to set the items conditionally to read only is one of the important security features in APEX. Using this feature you can secure your applications and it will not be possible to manipulate the protected item (region or page). The downside of this feature is that it will change the layout of the protected items to some kind of standard, ignoring the previous formatting in the "normal" mode. If you have a form (more...)

Working with multiple Trees on the same APEX Page (4.2/5.0)

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...)

APEX ReadOnly Pages – The easy way

If your Oracle APEX Application requires different types of access - full access or readonly - for different types of users, you can specify a Read Only Condition on Page level (or Region, Item, Button, etc.). 
You can set an Authorization Scheme on Application level, so it'll be applied to all pages. So if you have an Authorization Scheme named 'User Can Access Page' defined by a PL/SQL function like this:

return apex_authorization. (more...)

APEX 5 & Hackathon der Deutschen Bahn in Frankfurt

Wir alle wissen wie schnell es möglich ist mit Hilfe von Oracle APEX professionelle Anwendungen zu bauen. Nun wird es Zeit das Ganze in einer Challenge zu beweisen.

Die Deutsche Bahn veranstaltet am 21. und 21. März in Frankfurt am Main die DB Open Data-Train Challenge.

Ich werde Teil eines 4-Mann Teams sein und alles geben um APEX scheinen zu lassen. Um den Ganzen noch mehr Würze zu geben, werden wir die Anwendung mit einem (more...)

Oracle SQL: Calculate the amount of workdays (Mon-Fri) between two dates

I searched the net for a problem in finding a way to calculate the workdays between two date values. After I tested a couple of solutions I focused to one where I didn't necessarily need a extra select to solve that issue.

I found a post at asktom.oracle.com
The described function itself looked like that:
-- Created by Sonali Kelkar from Newton, MA USA
CREATE OR REPLACE FUNCTION num_business_days(start_date IN DATE, end_date IN (more...)

APEX 5.0: pimping the Login page

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...)

APEX Connect June 2015

APEX Connect in Düsseldorf in June 2015 is going to be the biggest APEX-only event in Germany so far. You should consider joining us.

APEX Connect in Düsseldorf im Juni 2015 wird der größte APEX-Treffen bisher sein. Meldet euch und hilft uns es noch erfolgreicher und größer zu machen. Viele interessante Vorträge und vor allem viele interessante Persönlichkeiten aus der APEX-Welt werden dort sein. Das ist eine ausgezeichnete Gelegenheit viel Neues zu erfahren. Anmeldungsformular kann (more...)

Loading CSV files with special characters in Oracle DB

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...)

Oracle Database Tools updated – check out SQLcl

Today Oracle released new versions of:

Also Oracle REST Data Services 3 got a new EA2 version.
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...)

APEX 5 EA Impressions: Page Designer (Part 3)

I think one part of the "Page Designer" is quite unfamiliar even to experienced APEX developers.

It is the "Grid Layout". Even I still struggle getting used to this new feature.
For that I will give you a small example how to read the new grid.
Maybe some of you have seen my example application about RaphaelJS.

I migrated this application into the new APEX 5 EA. Btw: No issues occurred.

What you see are (more...)

APEX 5 EA Impressions: Page Designer (Part 2)

In part 2 I want to show you a nice collection of valuable information about the new "Page Designer"

First link will lead to a great presentation from Scott Wesley (Nov 2014). It is a "must have" if you want to know more about the topic.

Next is information about a webinar presented by David Peake on Tue, Mar 31, 2015 6:00 PM - 7:00 PM CEST:

Until then you can watch (more...)

SQL Developer ORDS administration “peer not authenticated” error

How to resolve "peer not authenticated" error on SQL Developer ORDS administration

APEX 5 EA Impressions: Pager Designer (Part 1)

The development with the new page designer feels different.
Before you can say if it is good or not. You will have to make a whole APEX project and force yourself to only use the new "Page Designer" instead of the old "Component View".

So in this post I will show you where everything ended up when you compare the old dropped "Tree View" with the new "Page Designer".

First we take a look at (more...)