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>
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...)
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...)