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...)
My OCD was delighted this morning when I came across a new feature of SQL Developer: Connection Color. Brace yourselves, as this feature ain't much, but could have a huge impact on reducing accidental commands in the wrong schema or server.
To use it, simply create or edit a database (more...)
Prior to configuring Session State Protection in your applications you need to be aware of one important thing. Setting it up and configuring the settings will change the settings for all the items in your application - even if the items were protected before that change using some other protection (more...)
Ever since we started showing off the new Page Designer scheduled for release with Application Express 5.0 almost everyone has been hounding me for screen shots. Generally I never make future functionality public as it changes often and sometimes in very dramatic ways between feature conception, initial implementation, and (more...)