view counter


Oracle Application Express (APEX) resources, news, and support articles.

Suchen von Informationen innerhalb der APEX-Entwicklungsumgebung

Seit Version 4 von APEX ist es möglich, nach bestimmten Begriffen innerhalb der APEX Applikation zu suchen.
Beispielsweise: Wo verwende ich überall die Tabelle TBL_APEX_AT_WORK

Classic Report - Preserve Pagination after PPR

In this example you can see how easy it is to preserve report pagination after PPR. With a little jquery coding you can attach a function to the pagination request and this way "document" where the pagination goes. After a report refresh you may read those values and paginate back to where you were.

Getting started with Oracle Application Express (APEX)

There're still people just starting with APEX, so here's a quick post which might help them.

On there's a nice section about how to get started with Oracle APEX.

Get on Board the ARC

Yesterday, we launched the new APEX Resource Center - or ARC - on  The ARC was designed to provide the APEX experts at Enkitec with an easy way to share all things APEX with the community.  It’s split up into a number of different sections, each of which I’ll describe here:

SQL Developer 4.0

I personally didn't like SQL Developer because of it's clumsy java interface and found TOAD much better. Now, the version 4.0 looks more professional, cleaner and nicer. The new look and feel has been improved a lot. You can now reorder editor tabs without any side effects. SQL Developer has a big advantage if you have to work on a device for which you have no administrative rights - it doesn't require an installation. It is almost perfect if there wouldn't be a funny logic for making it available.

Time to update your APEX development environment

In the last days (and weeks) Oracle has been updating many of the tools a typical APEX Developer uses day-in-day-out.

Here's a graphical overview of a typical APEX configuration:

Oracle Application Express 4.2.4 now available

As an early Christmas present / late Hanukkah present, Oracle Application Express 4.2.4 is now released and available for download.  If you wish to download the full release of Oracle Application Express 4.2.4, you can get it from the Downloads page on OTN.  If you have Oracle Application Express 4.2, 4.2.1, 4.2.2, or 4.2.3 already installed, then you need to download the APEX 4.2.4 patch set from My Oracle Support.

Disable input elements in tabular form

There is a quite often requirement to disable a tabular form column based on the row information.

I got a customer request with the following requirement:
A select list column of a tabular form should be disabled (row based) when the value of another column is like SYSDATE.

There are 3 options to follow:
1. Create a manual tabular form and disable the column with a case statement inside the select
2. Deactivate the column with some jQuery code
3. Wait for APEX 5. I think there is some development ongoing about this problem.

view counter