Little League, Big Data

Last week, I participated in my first Little League draft for my son's baseball team.  This was new territory, as up until now, play has been non-competitive.  This year we will actually have to keep score, and there will be winners and losers.

In preparation for the draft, we had tryouts a few weeks ago where we evaluated the kids on a number of different criteria.  Never have I seen so many scared 7 and (more...)

IR Scrolling – With a Little Help From My Friends

If you are working with interactive reports you will for sure be faced with a problem of wide reports. If you are taking care of the page layout and eventually have more than just an interactive report on the page, you will want to limit it's size to something making sense. The first problem will appear if you limit the width by setting the region attribute to something like this

style="width:830px"

and you will not (more...)

APEX 4.2.5 Tabular Form – Komischer Bug

In einem meiner Projekte habe ich etwas intensiver auf Tabular Forms gesetzt.

In gewissen Konstellationen habe ich immer wieder folgende Meldung nach einem Validierungsfehler erhalten:
Aktuelle Daten für tabulare Forms sind zu alt; die Quelldaten wurden geändert.
Klicken Sie hier, um Ihre Änderungen zu verwerfen und die Daten aus der Datenbank neu zu laden.


Eventuell auch in Englisch:
Current tabular form data is too old; the source data has been modified.
Click here to discard (more...)

APEX 5.0: the way to use Theme Roller

Once you have your new application created using the Universal Theme it's time to customise your theme with Theme Roller.

Run your application and click the Theme Roller link in the APEX Developer Toolbar:


Theme Roller will open. I won't go in every section, but want to highlight the most important sections in Theme Roller in this post:
  1. Style: there're two styles that come with APEX 5.0: Blue and Gray. You can start (more...)

Twitter und der Oracle SQL Developer

Der Oracle SQL Developer hat eine kurze und bewegte Geschichte hinter sich. Aus meiner persönlichen Sicht ist die Software inzwischen wirklich gereift, läuft performant und wirkt immer noch nicht überfrachtet. Nichts desto trotz gibt es auch im SQL Developer eine Reihe versteckter sehr nützlicher Features. Um diese den Leuten näher zu bringen, hat das Oracle SQL Developer Team einen sehr eleganten Weg gefunden. Sie nutzen einen Twitter Account OracleSQLDev. Unter diesem werden immer wieder die (more...)

APEX Anwendung importen und exportieren mit Hilfe des SQL Developers

Wussten Sie das der Oracle SQL Developer eine sehr gute APEX Integration bietet? Ich möchte dies Anhand der Import und Export Fähigkeit näher demonstrieren.

Im SQL Developer gibt es im Navigationsmenü neben den üblichen Verdächtigen (Tabellen, Funktionen, Triggern, ...) auch einen Punkt Namens: Application Express
Wenn Sie diesen öffnen, dann sehen Sie alle installierten APEX Anwendungen die auf das Schema referenziert sind.

Export
Über die Rechte Maustaste > Schnell-DDL > In Datei schreiben... können Sie (more...)

Screaming at Each Other

Every time I attend a conference, the Twitter traffic about said conference is obviously higher.  It starts a couple weeks or even months before, builds steadily as the conference approaches, and then hits a crescendo during the conference.  For the past few conferences, I’ve started my sessions by asking who in the audience uses Twitter.  Time and time again, I only get about 10-20% of the participants say that they do.  That means that up (more...)

The most frequently abused feature in APEX

Today I participated in the Scott's survey:

https://apex.oracle.com/pls/apex/f?p=70347:Q::AAC3

and there was one really interesting question:

"What do you think is most frequently abused? (and why)"

If APEX has any week points than it is definitely the fact that you can place your code almost everywhere. Especially PL/SQL chunks of code. If I start counting and list all the places it will be a very long list:

  • Page Read Only and Cache Page (more...)
  • Alert Function

    In APEX you will probably use javascript alert function in many cases by saying:

    alert ('some message');

    The popup box you get looks a bit strange and outdated. As an alternative to this you may use this function call:

    function get_alert (p_message,p_id) {$("<div/>", { "html":p_message}).attr({"title":"Error has occurred!"}).dialog({
    modal:true,
    buttons:{"Go to Error":function(){$(this).dialog("close");
    $(p_id).select();}}
    }); }


    As you can see in this example, you can add additional functions to this alert box (more...)

    APEX Jobs

    Alle, die eine Beschäftigung mit Oracle APEX suchen, sollten hier reinschauen:

    Joel's Blog

    Auch einige Stellenangebote aus Deutschland und Schweiz.



    Tabular Form, Dynamic Action und Neue Zeile

    Einige von euch haben bestimmt schon die ein oder andere jQuery Codezeile in einem Tabular Form verwendet.
    Das Ganze funktioniert recht zuverlässig solange der Button "Neue Zeile" nicht verwendet wird. In diesem Beitrag geht es darum, auch auf neue Zeilen reagieren zu können.

    Angenommen ich habe in meinem Tabular Form eine Spalte mit einem Textfeld und will den Wert nach dem ändern in eine andere Spalten im Tabular Form übernehmen.
    Dazu muss zunächst in der (more...)

    Some changes to be aware of, as Oracle Application Express 5 nears…

    As the release of Oracle Application Express 5 gets closer, I thought it's worth pointing out some changes that customers should be aware of, and how an upgrade to Oracle Application Express 5 could impact their existing applications.


    1. As Trent Schafer (@trentschafer) noted in his latest blog post, "Reset an Interactive Report (IR)", there have been numerous customer discussions and blog posts which show how to directly use the gReport JavaScript object (more...)

    Custom CSV Export in APEX


    Sometimes the standard export doesn't fit your requirements. For example you do not want the double apostrophe ".



    In those cases take a look at these examples:

    http://spendolini.blogspot.de/2006/04/custom-export-to-csv.html
    http://www.brainre.org/oracle-apex-csv-file-download-with-iso-encoding-not-utf-8/
    https://community.oracle.com/thread/2318795

    Let us assume that this is our table:
      CREATE TABLE "MY_TABLE" 
    ( "ID" NUMBER,
    "CAR_NAME" NUMBER,
    "CAR_VALUE" NUMBER,
    "CAR_KM" NUMBER
    ) ;
    Based on this table I want to create the export.
    Next step is to create a (more...)

    Tabular Form – Regular Expression Validation

    A simple example how to check a tabular form column to be numeric with a max length of 2.

    Use a regular expression validation:

    APEX 5.0 Fixed Headings for Interactive Reports

    When you click on the Attributes of your Interactive Report there's a neath little new features included called "Heading - Fixed to" with as options: None, Region and Page


    We've got this request from many customers and it has always been a pain to get it working in every condition with APEX 4.x, but no hacking anymore - it's there now in APEX 5.0.
    When you start to scroll the column header will (more...)

    APEX 5.0 EA3 – Universal Theme Styles – Gray!

    In APEX 5.0 theme 42 is included - this is the Universal Theme. The theme comes with two styles: Blue and Gray.


    The UI is so much improved in APEX 5, it's really a game changer. When you look at the details for example from such a style you will see it's using a Less file (Less is a CSS pre-processor) behind the scenes. So it's very easy to make changes to the CSS. (more...)

    APEX 5.0 – Run Applications in New Tabs

    If you are using Firefox you will probably have an issue with running pages from APEX Builder 5.0 in new Tabs. Now, the links are working differently and normally clicking at button "Save and Run Page" will open a new window. In order to get it opened in a new tab, you will need a plugin Tab Mix Plus. Once you have it, you will need to change the settings there as shown in (more...)

    CloudFlare I trusted you :)

    For the past months I’ve been using CloudFlare on some projects, mainly web stores build with Magento and some CMS. For the most of them, CloudFlare works really great and I think CloudFlare is a great company. There’s lot of plugins to manage CloudFlare integration with e-commerce solutions and usually it’s pretty straightforward to get the best of it’s services.

    Lately I’ve been so busy working with new technologies such as NOSQL databases and reactive (more...)

    Test Drive Oracle APEX 5.0 Early Adopter 3!

    It’s here! Oracle Application Express 5.0 Early Adopter 3 is available at https://apexea.oracle.com/ and we are really looking forward to get your feedback (via the Feedback link in the Builder)! A list of all new features of EA3 and a … Continue reading

    APEX EA3 released

    The third and final early access release of Oracle Application Express (APEX) 5.0 is now released on http://apexea.oracle.com.  Our packaged applications now install much faster; I was able to install p-track (all 166 pages) in 22 seconds.  Our packaged apps now all use our new "universal theme", which is also available when creating custom apps.  The developer interface has been modernized and streamlined.  APEX 5.0 supports model dialogs, theme-rollable theme styles, (more...)