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...)
In REST you model the resources, not the actions. So you define a GET /apex/oow13/hr/employees
instead of a GET /apex/oow13/GetAllEmployees
. With REST you have six methods (with the most common associated database actions: GET (select), HEAD (select), OPTIONS (to get a list of methods supported by the resource), PUT (merge (more...)
In APEX 5.0 a Tablet User Interface will be introduced. The idea is not that you will end up with three user interfaces (Desktop, Tablet and Mobile), but use te Tablet UI for desktop usage as well. You might even want to use the Tablet UI - as an (more...)
A few weeks ago a new Oracle APEX book was released called Oracle APEX 4.2 Reporting
by Vishal Pathak.
I was one of the reviewers of the book and I really liked the content. The book covers many different areas of APEX and combines it with other knowledge (SQL, (more...)
Oracle Real Application Security (RAS) applies security policies at the database layer. So those policies are applied to the data and is not relying on the security built in into an application (like VPD). Security is applied to direct connections. Policies are stored in an "Identity and Policy Store".
In diesem November werden Denes Kubicek
und ich wieder einen Kurs zu Oracle APEX in Bensheim abhalten:
Wir werden diesmal viel über den APEX Listener, Einsatz von jQuery und über Restful Web Services reden und natürlich, praktisch üben.
Today the "Database as a Service
" has been announced. Not to confuse with the "Database Platform as a Service
" that was announced last year and is available since early this year. With the "platform" service, you get one schema within a database. With the "database" service, (more...)
Today the new In-Memory technique for the Oracle database has been introduced. This is not something like TimesTen(+) or so, but a new way of querying data. The concept is like this: All tables that are marked for keeping data in-memory, will be "stored" using both row and column format. (more...)
The Oracle Application Express (APEX) builder includes packaged and sample apps. In each dot release of Oracle APEX we improve these apps. The vision is two fold, provide best practice and clear examples of how to implement common application components like reports and charts (via sample apps) and provide out (more...)
APEX 4.2.3 seems to be largely a maintenance release, with few new features added. (Full details of what is included can be read here: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-423-patch-set-notes-2015119.html
Despite this fact, there are a couple of new "features" that were added by way of a new packaged (more...)