I’m starting to like Oracle Application Express (APEX) more and more every day.
I have used APEX to build a dashboard to monitor and report on all Oracle E-Business Suite (EBS) interfaces with external systems.
I am currently working on another dashboard for EBS concurrent programs. For that one I used APEX charts. They are really powerful and versatile. Here is a tutorial on how to use them.
The best thing of all, if you know SQL and PL/SQL you’ll be up to speed on APEX in no time.
Oracle recently published the Oracle Application Express statement of direction (SOD). I am very happy to see that Oracle continues to invest in the development and support of APEX and that new versions of APEX will be released annually.
In fact, the next new version will be 4.2 and according to the SOD, this upcoming version is planned to incorporate the following features:
4 Comments | Filed in Oracle | Tags: apexI think a best practice is really a contextual practice. I’m borrowing this term from Eric Ries, author of The Lean Startup. Ries writes that we should strive to understand the context which we find ourselves in, and then apply the practice which is best within that context. I couldn’t agree more. It’s not about blindly following steps or guidelines that may, or may not, be applicable and particularly useful in your situation. It’s about understanding. You’ve got to understand your situation and take steps that make sense in that context. Not simply take steps that worked for some other person, in some other context, at some other time, just because it is labeled as a “best practice”.
I couldn’t agree more.
Leave a comment | Filed in OracleIn his post titled learning foreign languages with Oracle SQL, Matthias Rogel shares the following query (I slightly modified and formatted it for clarity):
2 Comments | Filed in Oracle