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
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.
There're still people just starting with APEX, so here's a quick post which might help them.
On apex.oracle.com there's a nice section about how to get started with Oracle APEX.
Yesterday, we launched the new APEX Resource Center - or ARC - on enkitec.com. 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:
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.
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.
New version of the Oracle SQL Developer is out:
New features can be found here:
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.