Oracle VM Consulting
view counter

APEX Feed

Oracle Application Express (APEX) resources, news, and support articles.

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.

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

APEX 5.0: pimping the Login page

When you create a new application in APEX 5.0, the login page probably looks like this:

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.

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:

Oracle Database Tools updated - check out SQLcl

Today Oracle released new versions of:

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.

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.

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 the old "Tree View":

A good Rule of Thumb

I like the newest blog post from Joel Kallman and especially his rule of thumb:

"My rule of thumb - when you're editing code in a text area/code editor in the Application Builder of APEX and you see the scroll bar, it's time to consider putting it into a PL/SQL package."

I would go further and say that even the smallest application you create should have at least one package for all the PL/SQL code you write.



view counter