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 (more...)
Searching the APEX Forum for nice URLs is as old as Oracle APEX itself, so far without much luck. There is magic switch that forces APEX to create readable URLs.
As part of preparing my Presentation “Going Public” for Kscope 2014 in Seattle, I investigated the available methods on (more...)
When I develop APEX applications I use several browser tabs to navigate between the executed application and the application builder. There is one side affect which drives me crazy sometimes.
TAB 1: Executed application
TAB 2: Application Builder
How do I work?
I edit an item inside the application builder (more...)
After we successfully imported XML files
into our APEX application. It's time to start to analyze them.
We still assume that this is our example XML file:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<league id="1" name="2. Bundeliga">
<name location="Dresden" stadium="Glücksgas-Stadion">SG Dynamo Dresden</name>
If you are using APEX Listener version 2.0, you can download a sample application here
. In this application I am showing how to:
1. create an excel upload page
2. manage multiple excel sheets after upload
This new APEX Listener feature is great and I hope they will extend (more...)
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:
- You can search the blog posts at least back into the year 2008.
- Watch the last 100 posts
- No more problems (more...)
I was asked by an APEX developer if it is possible to dynamically update an APEX tree by changing an APEX item.
select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status,
ENAME as title
NULL as icon,
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 some major hints how to integrate XML files in APEX applications.
This time I will provide an easy way how (more...)
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 date" and work with the best technique on the market. A couple of colleagues mentioned the performance is better with Mac. (more...)
Would you like to upgrade your existing JasperReportsIntegration
with the 5.2.0 libraries of JasperReports?
As of now this already seems to be not the most current version, JasperReports has already moved on to 5.5.0. But since I have already created the 5.2.0 package a (more...)
Nachdem ich den Blogpost
von Joel Kallman
gelesen habe, dachte ich mir ein paar eigene Erfahrungen zum Thema APEX und Performance beizutragen.
Die Aussage APEX sei ein langsames inperformantes Tool, ist einfach nur FALSCH!
Wenn jemand ein Auto mit angezogener Handbremse fährt, dann liegt die langsame Geschwindigkeit nicht am Auto (more...)
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 save a lot of SQL executing time.Another positive side is:
The amount of code lines is also less then the other two solutions would need.Negativ (more...)
For years, I've been fighting
the perception by some customers that "APEX is slow". Back in 2010, I opined
about the corporate architect who didn't like Oracle Application Express because it was slow and couldn't scale. What helped him form his opinion? They had a business unit that developed a (more...)
Are you interested in developing Mobile web applications with Oracle Application Express? Do you want to see some of the features that are going to be introduced with Oracle Application Express 5.0? Then join us at the Bulgarian Oracle User Group Conference, taking place in Plovdiv, Bulgaria from November (more...)
Yesterday, I was part of the KScope 14 APEX Abstract Review call. This call is used to discuss the rankings that the Abstract Review Committee has previously given each session. Naturally, we use APEX to help with this process - specifically WebSheets. The call allows us to ensure that the (more...)
When updating my OS X to Mavericks, the Mail app started to behave differently for my GMail (Google Apps) accounts.
Whenever I moved a message from my Inbox to a folder the message wasn't removed from my Inbox. On the forum and on some sites (e.g. DigitalTrends
) the (more...)
Found some interesting pieces on how ORACLE TEAM USA used Application Express to help them win the 34rd America's Cup in San Francisco.
Of course these and (more...)