Recent Posts

APEX-AT-WORK no image

The APEX CONNECT and the APEX dashboard competition 2016

Von Tobias Arnhold → 4.30.2016
Before I tell you about the APEX dashboard competition winner I want to share my impressions from the APEX CONNECT 2016 in Berlin with you.

We had 3 days fully packed with APEX, SQL, PL/SQL, SQL Developer and different JavaScript technology topics.

In every way Niels de Brujin, Carsten Czarski, Christian Schwitalla and the whole DOAG team created an amazing event and has raised the quality compared to the last year.

We had more attendances, more international speakers and all known national speakers on board.
In my opinion and what I have heard from others, the general quality of the presentations has increased as well.

Thank you for letting me enjoy the event and be part of this great community!

What made the event so special? Before I start to write two more pages I decided to show you the uniqueness by letting the community speak:

THE LOCATION


THE GUYS WHO MADE IT POSSIBLE

THE #ORCLAPEX COMMUNITY

THE SPEAKERS


THE LEGEND

THE NEW STUFF WE WERE WAITING FOR

THE APEX DASHBOARD COMPETITION

THE TWITTER COMPETITION


THE STICKERS

THE CITY


MY OWN PRESENTATION
AND EIGHT HOURS BEFORE :)

MEETING MY FRIENDS FROM MY LOCAL USER GROUP

ASK THE GURUS

DAY 2

LAST BUT NOT LEAST: THE NEW ONES!


Now I'm happy to announce all winners including their applications:



WINNER:
Pavel Glebov
https://apex.oracle.com/pls/apex/f?p=7777708

SECOND:
Dick Dral
https://apex.oracle.com/pls/apex/f?p=7777710
Description: http://dickdral.blogspot.de/2016/04/apex-world-dashboard.html

THIRD:
Till Albert
https://apex.oracle.com/pls/apex/f?p=7777702

4.:
Sebastian Reinig
https://apex.oracle.com/pls/apex/f?p=7777704

5.:
Trent Schafer
https://apex.oracle.com/pls/apex/f?p=7777701
Description: http://apextips.blogspot.de/2016/04/the-making-of-my-apex-competition.html

6.:
Daniel Balzer
https://apex.oracle.com/pls/apex/f?p=7777711

7.-10.:
Arthur Rinberger
https://apex.oracle.com/pls/apex/f?p=7777712

7.-10.:
Matt Mulvaney
https://apex.oracle.com/pls/apex/f?p=7777709

7.-10.:
Sven Weller
https://apex.oracle.com/pls/apex/f?p=7777703

7.-10.:
Ronny Weiß
https://apex.oracle.com/pls/apex/f?p=7777705

11.-13.:
Peter Raganitsch
https://apex.oracle.com/pls/apex/f?p=7777707

11.-13.:
Archana Hebbar
https://apex.oracle.com/pls/apex/f?p=7777714

11.-13.:
Renat Kalimulin
https://apex.oracle.com/pls/apex/f?p=7777706

THE DOWNLOAD IS NOW AVAILABLE ON: http://apexcompetition.org/

Add browser recognition on page inline CSS

Von Tobias Arnhold → 3.04.2016
Today I will show you an example how you can add browser recognition inside the "Inline CSS" mask of your APEX page.

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 me about 2 minutes instead of googling around.

In this example I will show you how to
- create an APEX_COLLECTION
- select the data in APEX reports
- analyze APEX_COLLECTION in SQL Developer

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
     , area_used_for_bio_cropland
     , area_used_for_forest
from   gdb_world_agriculture_area
where country in 
( select country 
from   gdb_world_agriculture_area
where  area_used_for_forest is null
intersect
select country 
from   gdb_world_agriculture_area
where  area_used_for_forest is not null
) order by 1, 2
;

-- Bugfix
update gdb_world_agriculture_area
set    area_used_for_forest        = area_used_for_bio_cropland
     , area_used_for_bio_cropland  = null
where country in 
( select country 
from   gdb_world_agriculture_area
where  area_used_for_forest is null
intersect
select country 
from   gdb_world_agriculture_area
where  area_used_for_forest is not null
) 
  and area_used_for_forest is null
;

In den letzten Tagen wurden mir mehrere Fragen rund um die APEX Dashboard Competition gestellt. Die Fragen und Antworten möchte ich gerne teilen:

Frage:
In wieweit darf man das Universal Theme ver√§ndern? Darf die Anordnung der Regions ge√§ndert werden? Darf das Men√ľ links entfernt werden?
Antwort:
Sie können mit dem Universal Theme machen was Sie wollen.
Einzige Einschr√§nkung: Das Theme sollte nicht unter einer anderen ID abgespeichert werden. Dann w√§re es ein Custom Theme und w√ľrde nicht mehr den Wettbewerbsregeln entsprechen.

Frage:
Ist es erlaubt externe Javascript Libraries wie D3JS zu verwenden?
Antwort:
Ja, es ist sogar zu empfehlen. Einzige Regel ist, dass alle verwendeten Libraries Open Source sein m√ľssen.
Info: Es gibt beim Thema D3JS eine ganze Menge an fertigen Plugins, zu finden in den APEX 5 Packaged Applications und unter apex.world.

Frage:
Kann ein jQueryMobile Template verwendet werden?
Antwort:
Nein.

Frage:
M√ľssen alle Tabellendaten verwendet werden?
Antwort:
Nein, Sie bestimmen den Umfang der Nutzung selbst. Keine der bereigestellten Daten zu verwenden wäre aber auch keine Lösung. :)

Frage:
Können eigene Daten verwendet werden?
Antwort:
DML Skripte sind nicht erlaubt. Es gibt aber die Möglichkeit sich eigene Daten via APEX-Collections oder der SQL WITH-Klausel bereitzustellen.

Frage:
Können komplexe PL/SQL Lösungen in Packages ausgelagert werden?
Anwort:
DDL und DML Skripte sind per se nicht zulässig.

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 issues like that and found a forum post where someone else was experiencing the same problems as I did:
File browse changes some NLS settings - possible bug

My purpose was to upload a CSV file and transforming it to table data. Now I couldn't handle NUMBER values anymore. I always experienced the following error:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

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 L√§nder der Erde in einer WITH Clause zusammengefasst und bilde mir anhand des Namens einen sp√§ter verwendbaren normierten String.

Der Zielstring muss GROSSGESCHRIEBEN sein und darf keine Umlaute (√Ė√ú√Ą√∂√ľ√§√ü) und Sonderzeichen (, '.()-) beinhalten.

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 side. You should not be allowed to remove values from the right side.

The result should look like that: