Blog

Beiträge aus der Praxis mit Oracle APEX. Die älteren stammen aus dem Blog apex-at-work von Tobias Arnhold.

  1. Interactive Grid: Automatic Position Numberenglisch

    If you want an automatically increasing number column in your Interactive Grid, follow these instructions: a hidden item, one computation and a dynamic action on row initialization.

  2. Interactive Grid: After Update Triggerenglisch

    Run a process after the Interactive Grid has saved all rows, then refresh the recalculated columns inside the grid. A dynamic action on the Save event does both.

  3. APEX CONNECT 2020 [ONLINE]englisch

    You may already noticed..

  4. utPLSQL - Example Packageenglisch

    A few months ago I got an awesome task to do inside the fabe project:

  5. Interactive Grid: Validation - Check for duplicated column entries over all rowsenglisch

    I had this situation now a few times and was always to lazy to write it down. :/

  6. Die inoffizielle APEX Connect Agenda

    Noch etwas mehr als einen Monat bis zur APEX Connect 2019 und so langsam steigt bei allen die Vorfreude. Dieses Jahr wird es neben dem voll gepackten…

  7. And the APEX Coin goes to...englisch

  8. Der Fahrplan bis zur APEX Connect 2019

    Im Mai 2017 hatte ich euch gefragt worauf ihr euch am meisten freut was die damals anstehende APEX Connect betraf.

  9. Modal Dialogs Part 1 - Introenglisch

    In this 5 part series of blog posts I will share my understanding of how you can open modal dialogs with dynamic values.

  10. Interactive Grid - Column stretchingenglisch

    Since APEX 18.1 you can define the stretch behavior per column.

  11. Eine verrückte Zeit endet...

    ich habe leider eine schlechte Nachricht zu verkünden. Ich trete als Leitungskraft innerhalb der DOAG NextGen-Community zurück. Das kommt leider nicht nur…

  12. Set the APEX application name for Dev, Test and Prod in the same databaseenglisch

    Development, test and production of a small application share one database and differ only by application ID. A page-zero dynamic action names the environment in the logo.

  13. Copy and paste to clipboardenglisch

    Two ways to copy the content of a textarea to the clipboard in APEX: a dynamic action with two lines of JavaScript, or the Copy to Clipboard plugin by Dick Dral.

  14. Enable save button on form changeenglisch

    Keep the save button disabled until a form item changes: a static ID, the disabled attribute and a three-line dynamic action on page load.

  15. Check inside your APEX application if debug mode is enabledenglisch

    A condition that is true only while APEX runs in debug mode: APEX_APPLICATION.G_DEBUG returns a boolean, not the "Yes" or "No" the documentation suggests.

  16. Interactive Report: Column background colorenglisch

    Give half of the columns in an Interactive Report another background colour: a static ID per column and one CSS rule that matches the ID prefix.

  17. SQL Developer: Quick Outline with SQL statementsenglisch

    Most of you probably know the "Quick Outline" function you have inside the SQL Developer. It helps you to easily jump between different functions/procedures…

  18. APEX Master (Interactive Report) - Detail (Modal Dialog) Form: Conditional Column Linkenglisch

    Since APEX 5 it is much easier to create master-detail pages with modal dialogs. But there is still no declarative way to create a conditional row based…

  19. Using dynamic tooltips in your Interactive Reportenglisch

    Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be…

  20. CREATE an APEX_COLLECTION and SELECT the data via SQL Developerenglisch

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

  21. Show all views including a specific string in the source codeenglisch

    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:

  22. Importing XML file with invalid character 22 (U+0016)englisch

    I have to import a set of XML files from time to time. Most of those XML files can be imported with out any problems. But at least one file includes a…

  23. Generierung von Bitlisten mit Hilfe von SQL am Beispiel einer Datum zu Monat Konvertierung

    Ich hatte vor kurzem die Aufgabe erhalten eine Bitliste auf Basis eines Monats zu generieren. Bedeutet, ich habe einen String mit 31 Zeichen der je Zeichen…

  24. SQL: Calculate the past time between two dates in percentenglisch

    Just a simple example how easy APEX can handle this kind of problem.

  25. Oracle SQL: Calculate the amount of workdays (Mon-Fri) between two datesenglisch

    I searched the net for a problem in finding a way to calculate the workdays between two date values. After I tested a couple of solutions I focused to one…

  26. APEX Anwendungen importieren 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.