
SQL Developer 4 and APEX 4.2.4 are out
New version of the Oracle SQL Developer is out: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html New features can...
New version of the Oracle SQL Developer is out: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html New features can...
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...
When I develop APEX applications I use several browser tabs to navigate between the executed application and the application builder. There is one side...
After I described how to successfully import XML files into an APEX application. It's time to start to analyze them. I still assume that this is the...
Check out the updated blog aggregator on http://www.odtug.com/apex Finally some major usability extensions were integrated. Looks like APEX to me. Advantages:...
I was asked by an APEX developer if it is possible to dynamically update an APEX tree by changing an APEX item. Example select: select case when connect_by_isleaf...
Working with Oracle and XML can be a pain in the ass especially at the beginning when you don't know the hidden secrets. :) That's why I want to give...
A year ago I bought a Macbook Pro and tried to develope APEX applications with it successfully. You may ask yourself why? I just want to stay "up to...
Nachdem ich den Blogpost von Joel Kallman gelesen habe, dachte ich mir ein paar eigene Erfahrungen zum Thema APEX und Performance beizutragen. Die Aussage...
I'm actually a big fan of using analytical functions instead of using SUB-Selects or custom PL/SQL functions. The reason is quite simple: You...
Using iFrames can sometimes be really helpful. Especially if you have information which should be served on several pages. A simple solution using the...
Eigentlich eine simple Anforderung. Baue eine mobile Eingabemaske mit einem zusätzlichen Feld für eine digitale Unterschrift. Wie für sehr vieles im...
Vor über einem Jahr habe ich eine Pivot Beispiel Applikation gebaut und diese bei einem DOAG Treffen präsentiert. Wie ich in den letzten Wochen bemerkt...
Seems to be a simple task but there are hundreds of solutions. For me as an APEX developer I have to decide between an JS/jQuery or a SQL/PLSQL solution. Easiest...
Actually I'm impressed from the speed (even so it is a Java based application), the easy handling and the integration into APEX. For example remote debugging...
I often have used UPDATE and INSERT statements during my development. In some complex updates especially when I had to select from other tables I sometimes...
Seems to be a simple problem. I have and grouped report where I want to see all facilities on a address. For example: Grouped View EditAddressAmount...
Take a look at this little goody: http://apex.oracle.com/pls/apex/f?p=29999:1: Nice idea....
I had the task to show the amount of displayed rows from a standard report on another position of the page. As "Pagination Scheme" in the "Report Attributes"...
This little snippet of code will expand the APEX tree: $("input:[value='Expand All']").click(); This solutions finds the HTML objects by the displayed...
I just found this little piece of code to create DDL source code. SELECT dbms_metadata.get_ddl(replace(OBJECT_TYPE, ' ', '_'), OBJECT_NAME,OWNER) as...
During one of my projects I had an issue when I copied the DDL from my test environment into my productive system. Unfortunately I needed some of the...
Eine der häufigen Anforderungen in der APEX Entwicklung ist es, einen änderbaren Report (Tabular Form) anzulegen bei dem einzelne Spaltenwerte verändert...
I already posted a forum entry to the topic but no one had answered yet. I think the bug is a real problem so people should know about it: https://forums.oracle.com/forums/message.jspa?messageID=10840734#10840734...