Working with disabled textfields

In APEX you have the possibility to disable text fields.
Unfortunatelly you can not submit those fields after the value was changed by a dynamic action or some javascript code.
Out of a security point of view in most cases this makes sense.

In case you do have to change the value during the runtime and need to send it to the database.
First all textfields must be enabled. Now create two dynamic actions using (more...)

Oracle SQL regular expression – check for numbers or special characters

We all know the regular expression syntax is fast and you can do amazing things with little code snippets. But we do know as well that whenever you need it then you have no idea how to write it down. To be able to find a solution for your problem you use the WWW.

So here you have another example you may need one day. :)
I had to check a string for special characters (more...)

Calculate all unique combinations of one list (cartesian product)

A couple of day ago a had a task to combine a list with itself. The result should be a two column report of each possible combination.

What should note be part of the result:
- same element combination should be excluded
- duplicate rows (even if the sides are switched)

Because I was just not able to solve it myself *actually it's awful after I now know how to do it* I had to (more...)

Working with XML files and APEX – Part 3: Detail elements in a row with OUTER JOIN

After I described how to successfully import XML files into an APEX application and gave some basic information about the analyzing of xml data.
It's time for another example. This time we want to get all detail elements of a master element in one row.
Example XML data:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>  
<data>
<stadium>
<team name="SG Dynamo Dresden" league="3. Liga"/>
<event name="Konzert"/>
<event name="Stadionführung"/>
</stadium>
<stadium>
<team name="RB Leipzig" league="2. Liga"/>
<event (more...)

Oracle CONNECT BY Anzeige der maximalen Verkettung

Der Umgang mit CONNECT BY ist für mich immer wieder ein Highlight. Ob Positiv oder Negativ lasse ich mal außen vor. :)
Unbeachtet meiner Meinung ist es die sinnvollste Lösung um Baum-Verkettungen zu generieren.

Eine Anforderung die ich zuletzt gleich zweimal lösen musste war die Darstellung der finalen Ketten.

Beispiel Quell-Daten:
1:
1:2
1:2:3
1:2:4
1:6
1:6:1

Beispiel Ziel-Daten:
1:2:3
1:2:4
1:6:1

Das Ganze war recht einfach mit Hilfe einer analytischen Funktion zu lösen:
--  (more...)

APEX Hinter dem eisernen Vorhang… ;)

Schaut euch den Tweet von @shakeeb an: https://twitter.com/shakeeb/status/547859282847617024?s=09