UKOUG Tech14 – APEX Highlights




Last week I spent 4 days at the annual UK Oracle User Group conference, this time around called Tech14.  It was my first UKOUG conference in a number of years and I set out with the intention of treating it like an all you can eat buffet of APEX presentations and workshops.

So, what were the APEX highlights of Tech14? Well, I have to start with the presentations given by Joel KalmanDavid Peake (more...)

Can you build business critical applications with APEX?

Now and then this question pops up. And today this question was delivered to my mailbox again. A customer is busy starting a project to replace a current Oracle Forms application. So he asked Oracle and one of the Oracle partners: What should we use, APEX or ADF? A valid question that has been asked - and will be asked - by numerous customers. 
Of course, there is only one correct answer and that (more...)

UKOUG 2014 – A special edition

Although I’ve attended the UKOUG conferences since 2008, this year’s edition was somewhat special to me. Based on the attendee reviews of last year’s UKOUG, I was elected as “Best Overseas Speaker”. And for me that’s quite an honour and of course a recognition for years of work - and practice ;-)
And with a title comes a plaque - it’ll get a special place on my bookshelf. 

I didn’t just get (more...)

Fun with Bubbles – Part 2



In my previous post a couple of days back, I demonstrated a simple Apex demo with D3 pulling dynamic data from the database in the form of a bubble chart.  I promised to share the code so here it is.

It's really quite simple.  In short, i've created a table, D3_COUNTRIES, which contains 10 sets of rows each with a country code, name and a value.  The Javascript code on the page has an interval (more...)

Fun with Bubbles!

I'm on a train up to Liverpool for the UK Oracle User Group Tech 14 conference, and decided it's about time for a post showing something I've been working on.  I don't post often these days, which I blame on work and family commitments, but is actually just down to pure laziness.  Anyhow, I'm feeling in the mood so I'll just get on with it in case the desire to catch some zzz's becomes overwhelming. (more...)

Good Blog Bad Blog

Just checked if the http://www.odtug.com/apex is available again and it is. It seems the people there are filtering blogs because I don't see my blog post from yesterday appearing there and I don't understand why. Is that just because I said that the old blog listing was much better? Or this is just another technical problem they have? Am I going to be removed from that blog listing forever if I continue saying (more...)

APEX, HTML und Jahresausklang…

Die letzten Wochen waren verdammt arbeitsintensiv und es wird bis Weihnachten nicht viel besser werden. Meetings, Telko's, PL/SQL, SQL, APEX alles verpackt in unterschiedlichsten Projekten.

Umso mehr waren die 3 Tage #DOAG2014 eine gute Erholungspause und eine Quelle für neue Motivation und Ideen.

Mein eigener Vortrag zum Thema "Dynamisches Arbeiten mit Grafiken in APEX" kam sehr gut an und zeigt einmal mehr das APEX Enthusiasten auch am letzten Tag 09:00 Uhr bereit sind sich weiterzuentwickeln. (more...)

You shouldn’t think this happens only to you

Since several hours I am getting this while trying to access all blogs at http://www.odtug.com/apex. It seems that this list has a lots of problems listing all the relevant APEX blogs. The previous version from Dimitri was so much better and user friendly.

From Zero to Hero….In About 2 Hours



This is an example of a real-world problem, an opportunistic one, being solved via a mobile application created with Oracle Application Express.

First, a brief bit of background.  Our son is 9 years old and is in the Cub Scouts.  Cub Scouts in the United States is an organization that is associated with Boy Scouts of America.  It's essentially a club that is geared towards younger boys, and teaches them many valuable skills - hiking, (more...)

Value Placeholder

Did you know that you can use Value Placeholder in your page items to display hints for the users? This is a quite neat feature you can implement without using different plugins for displaying hints. It will also work with the APEX ampersand substitution strings like

&P1_ITEM.

Here is how it looks like. Be carefull with this. It will work only for the browsers supporting HTML5.

APEX Worst Practices – Survey

As preparation for my Presentation about Worst Practices in Oracle APEX I set up a survey using the Survey Builder Packaged Application.

Please help out and fill in the survey: https://apex.oracle.com/pls/apex/f?p=80076:Q::AAAW

There will be a follow up post with details on worst practices and survey results.

 

Thanks for your time,

Peter

APEX 4.2 interactive report with row detail

Interactive report with the functionality to show a detail row per each row

APEX Tabular Forms Deep Dive at #ORCLAPEX NYC Meetup

Ever heard of APEX$ROW_NUM, APEX$ROW_SELECTOR and APEX$ROW_STATUS? Did you know you can reference tabular form columns using bind variable syntax in your page processes? Are you familiar with the execution scope of tabular form proecesses for modified vs submitted rows? Ever struggled using apex_application.g_fxx arrays with checkboxes? And do you really need to use the apex_item APIs? In APEX 4.0, 4.1 and 4.2 we've introduced lots of new tabular form features, (more...)

APEX Connect 8th and 9th of June 2015 in Duesseldorf Germany

APEX Connect is the first big APEX event in Germany and will be taking place in Duesseldorf on 8th and 9th of June 2015. You can still apply for a presentation using this link. I will be there with a presentation on APEX Plugins. As far as I know a couple of international guests are expected to be there as well. This event will for sure be interesting and informative so you should think about (more...)

MS Sharepoint and Oracle APEX integration

At Oracle Open World I gave a presentation about the integration of Microsoft Sharepoint and Oracle Application Express (APEX).

I see a lot of companies using Microsoft Sharepoint as portal for their intranet. For many people it’s the first place they go to when they start their day. But to do their job they make also use of other applications, some which are build in Oracle Application Express (APEX). This presentation will show the different (more...)

APEX and shuttle filter

How to create filter / search field for APEX shuttle item values using jQuery.

APEX 5.0 verschiebt sich

APEX 5.0 wird erst im Jahr 2015 erscheinen!

Alle Details findet Ihr hier: https://blogs.oracle.com/apexcommunity_deutsch/de/entry/openworld_update_application_express

Imho: Qualität hat seinen Preis! :)

APEX 5.0 New Features – Terminverschiebung

leider müssen wir den Termin für den bei uns gebuchten Kurs "Oracle APEX 5.0: New Features" (Termin: 08/09.12.2014) auf den Februar 2015 (09.02/10.02) aus gegebenem Anlass verschieben.

Wie Sie/Ihr bereits bestimmt erfahren haben, wird sich das Release von Oracle APEX 5.0 etwas verschieben: https://blogs.oracle.com/apexcommunity_deutsch/de/entry/openworld_update_application_express.

Sie können sich hier zum Kurs anmelden.

Is Oracle Application Express supported?


Time to clear up some confusion.

In the past 60 days, I have encountered the following:
  • Two different customers who said they were told by Oracle Support that "APEX isn't supported."
  • An industry analyst who asked "Is use of Oracle Application Express supported?  There is an argument internally that it cannot be used for production applications."
  • A customer who was told by an external non-Oracle consultant "Oracle Application Express is good for a (more...)

Oracle APEX 5 Update from OOW

The big news about Oracle APEX from OOW is not so much about what, but more about when.  Much to many people's disappointment, APEX 5.0 is still going to be a few months out.  The "official" release date has been updated from "calendar year 2014" to "fiscal year 2015".  For those not in the know, Oracle's fiscal year ends on May 31st, so that date represents the new high-water mark.

Despite this bit of (more...)