After the party is before the party

Now two months after the #pougtrip everything went back to normal. Except the planning for the next events.

The DOAG #NextGEN is currently starting a "roadshow" at German universities.

Start is the 07.11.2017 at the university of Trier. We will have 3 presentations covering different technologies: SQL, JS, JSON, SVG, PL/SQL, REST and APEX.
But see for yourself: Oracle Vorträge an der Hochschule Trier


As you can see the agenda is made with (more...)

The best Oracle technology week ever – Part 1: Helsinki and Stockholm

You remember my last blogpost describing how my #europeTour would be like:
#orclapex Europe tour 

It was a week with as little sleep as possible. Reasons:
 - traveling
 - just was to excited
 - to much party

It all started in Helsinki with the first Oracle APEX day in Finland.
I reached Helsinki with Richard Rieb around 10 o'clock in the evening. It was dark and cold, our taxi driver spoke 5 words to (more...)

#orclapex Europe tour

From Tuesday, the 29. of August until the 02. September, I will meet the best experts around Oracle.





But first some background:
Last year I was in Sweden and held a presentation at a meetup in Stockholm about APEX. I met Mathias Magnusson an Oracle specialist who is organizing all kinds of Oracle usergroup events in Sweden. I was lucky to meet him again at DOAG 2017 and introduced him to Joel Kallman. During (more...)

DOAG #NextGEN goes POUG

Hallo liebe Oracle Community,

die letzten Wochen und Monate waren etwas sehr hektisch, daher hatte ich auch keine Zeit für Blogposts rund um Oracle und APEX. Der Grund, lag in meiner Aktivität in der DOAG #NextGEN Community. Wir als Community planten ein Studenten- und Azubi-Event für Oracle Technologien.

Heraus kam dieses Jahr eine Reise zur POUG nach Krakau zu unternehmen.


Mit dabei sind die bekanntesten Oracle Speaker aus ganz Europa.


Und genau dieses Event das (more...)

APEX CONNECT and POUG High Five

Next week the APEX CONNECT 2017 will start. Besides the latest News about Oracle APEX you will have the chance to talk to some of the best developers worldwide.
As I mentioned at the beginning of the year "A new year promises new possibilities!" I'm focusing on students and will hold a presentation about "Next Generation - Erreiche die Mitarbeiter von Morgen".
Besides that I'm always willing to help others so if you have (more...)

JET pie chart in APEX with absolute numbers as data labels

The new APEX pie charts only allows percent values as data labels. Luckily the APEX team added an great example in the "Sample Chart" application which shows how to add custom data labels including absolute values by adding custom JavaScript code.

For German applications I prefer to display 10k (10000) like this: 10.000.
Thanks to APEX and JET it is easy to implement.

function( options ){
    this.donutSliceLabel = function( dataContext ){
        (more...)

Interactive Report Download Button only for a certain Authorization Role

The Interactive Report has this great download feature where you can export everything you can see.
Anyway there are circumstances where the customer doesn't want that feature open for everyone.

In APEX you can only choose if you want the download button or not.
Even so APEX can't do it out of the box. There is a way to make your application able to do it.

Since APEX 5 you can't download when the "Download" (more...)

An introduction into the APEX 5.1 Layout View

Many of you are still using the old "Component View" but the "Page Designer" introduced in APEX 5 made the developer life much easier.

The top 5 most time saving abilities for me are:
 1. Easy access on all page elements (without any page refresh)
 2. Copy&Paste of items, regions, dynamic actions, ... 
 3. Drag&Drop moving of items and regions
 4. Multi edit of items
 5. Since APEX 5.1: The ability to customize your (more...)

Customize your Interactive Report with CSS

A lot of you are using jQuery to customize visual parts of an APEX application. I probably to often do so myself but there is a much more elegant way:   CSS

Nowadays you are able to add different kind of rules into your CSS styles. In this example I will show you how to get into the topic by changing an Interactive Report (IR). In my example I want to change the typical group by (more...)

Run dynamic action from report row and pass multiple variables

Execute a "Dynamic Action" by clicking on a button/link inside a report row is mostly handled by some triggering HTML class.


It actually works in 95% of all cases. But it is not the best way to do it. It is much more effective to execute the "Dynamic Action" with a custom event.

Reason is simple: You don't need to allocate unnecessary elements via a class by jQuery. You execute the "Dynamic Action" in the (more...)

Using APEX_ERROR to manage custom error messages

Sometimes you just feel like you would be a newbie in coding business applications. Luckily it doesn't happen so often anymore. But this time it hit me hard. :)

During an application upgrade on Universal Theme I discovered an ugly workaround to create custom error messages I used in that time.

The old code looked like that:
declare 
retval number;
p_cust_id number;
p_status varchar2(30);
p_upduser varchar2(10);

begin
p_cust_id := :p1_cust_id;
p_status := 0;
p_upduser := (more...)

APEX IR column only exportable for administrators

A few days ago I tweeted about a solution from Martin Giffy D'Souza to hide a specific column from export.


In my case I needed some username columns to be displayed during run-time but only exportable for administrators. The export itself was made with the default APEX (more...)

A new year promises new possibilities!

The last year was quite successful even so it was a pain in the ass in many ways.
I have been on 3 conferences, made a few blog posts, got member at DOAG #NextGen, I initialized the "APEX Dashboard Competition" and I created a quite complicated example application which creates new solvable business cases for many of you: SVG in APEX.
This wouldn't be possible if I would have been alone. I worked (more...)

SVG in APEX: Best Practices

In the last 8 month I was working on a new version of my SVG (Raphaël) example application. Of course I have a job (freelancer) and I have children. So the time to spend was diminished on only a few hours per week mostly on my way to work.
Some of the results were presented at the Swedish Oracle meetup in Summer '16. But the final application was made for DOAG 2016.

What leads me (more...)

SQL Developer: Quick Outline with SQL statements

Most of you probably know the "Quick Outline" function you have inside the SQL Developer.
It helps you to easily jump between different functions/procedures inside a package.


My colleague Holger told me about a bug in SQL Developer 3.x where you could use the "Outline" view with normal SQL files, too. Unfortunately in version 4 it didn't work anymore. So he stayed with version 3 for a long while. Otherwise he would had to (more...)

Tablespaces verkleinern (TEMP, USER_TS, ORA-03297)


Info
Die Select-Statements in diesem Blogpost habe ich von anderen Webseiten kopiert. Daher ist dieser Beitrag eher als Zusammenfassung unterschiedlicher Lösungsversuche zu sehen und dient mir als schnelle Hilfe bei der Verkleinerung eines zu großen Tablespaces. Schaut euch die Quellen an, die sehr viel detaillierter auf die jeweiligen Probleme eingehen.

Wer kennt nicht die Situation? Der DBA ruft an und meint der TEMP Tablespace verbraucht mehrere hundert Gigabyte an Speicher.

Was ist in solch einer (more...)

DOAG 2016 Review


Die diesjährige DOAG war für mich anders als die Jahre zuvor. Dieses Jahr lag mein Fokus weniger auf Vorträgen, sondern mehr auf Community-Aktivitäten und Jugendarbeit.
Daher habe ich diverse Unconference Sessions besucht und viele Unterhaltungen geführt. Dabei habe ich zum Beispiel erfahren, dass es eine neue Community innerhalb der DOAG gibt  -  die DOAG NextGen. Bei der es darum geht, junge Menschen für Oracle zu begeistern.

DOAG 2016 und weitere APEX Events im November

Das größte deutschsprachige Oracle Event des Jahres steht vor der Tür.
Die DOAG Konferenz vom 15. bis zum 18.11.2016.

Wie schon in den letzten Jahren, bin ich auch dieses Jahr wieder mit dabei.
Mein Vortrag zum Thema "SVG in APEX" findet am Mittoch dem 16.11. um 13:00 Uhr statt.


Den Vortrag halte ich nicht allein. Sebastian Reinig ein sehr talentierter junger APEX-Consultant hält den Vortrag mit mir Zusammen. Sebastian hat (more...)

Open a windows directory from inside your APEX application (IE, Firefox, Chrome)

Back in 2010 I wrote about a solution for IE only: Open Windows directory with APEX (IE only)

The request itself appears at least once a year in one of my projects.
Nowadays I do not propose the workaround from 2010. It just doesn't fit in modern browsers.

Today I got another request to open a directory and this time I searched for 10 minutes and found a suitable solution working in IE, Firefox and (more...)

Creating interactive graphics in APEX with Raphaël (RaphaelJS)

Some of you may know of my personal interest for SVG interaction in APEX applications. I have been working with a JavaScript library called "Raphaël" (RaphaelJS, raphael.js or just raphael) for a while now. It is an amazing plugin to create all kind of customized business solutions. But before I show you how I have used Raphaël I tell you how I came to the technology and what happened in the last few years.


(more...)