CREATE an APEX_COLLECTION and SELECT the data via SQL Developer

APEX examples

CREATE an APEX_COLLECTION and SELECT the data via SQL Developer

Von Tobias Arnhold → 2.29.2016

Maybe this an old hat but a lot of people don't know how to use and analyze APEX_COLLECTION properly.  For myself it is a good reminder and saves...

Fragen rund um die APEX Dashboard Competition

Fragen rund um die APEX Dashboard Competition

Von Tobias Arnhold → 2.23.2016

Update  14.03.2016: Dick Dral fand einen Bug in der Tabelle : gdb_world_agriculture_area -- Select zum nachstellen select country , year ...

APEX 5 - File Upload Bug

APEX issues

APEX 5 - File Upload Bug

Von Tobias Arnhold → 2.18.2016

Today I had to suffer on a real APEX 5 bug. When you upload a file the NLS settings in your current APEX session will be set to AMERICAN. I check for...

SQL: Texte mit Umlauten und Sonderzeichen normieren

SQL

SQL: Texte mit Umlauten und Sonderzeichen normieren

Von Tobias Arnhold → 2.16.2016

Im heutigen Beispiel möchte ich einmal kurz aufzeigen, wie Sie einen Text nach Ihren Bedürfnissen hin normieren können. Ich habe dazu die bekanntesten...

APEX shuttle item with one direction

APEX examples

APEX shuttle item with one direction

Von Tobias Arnhold → 2.04.2016

In one application I had the requirement to set up a shuttle item to be half readonly. All you should do was to add new values from the left to the right...

Show all views including a specific string in the source code

SQL

Show all views including a specific string in the source code

Von Tobias Arnhold → 2.02.2016

Seems to be a simple problem and easy to fix. Actually it is not because if you try one of these examples then you will fail...