Eddie Awad's Blog

8 Interesting Things You May Have Missed This Week

Eddie Awad — Sun, 13 May 2012 12:00:46 +0000

8 Interesting Things You May Have Missed This Week

Eddie Awad — Sat, 05 May 2012 18:28:55 +0000

Do You Know the History of These Oracle Database Performance Related Features? Take the Quiz

Eddie Awad — Tue, 01 May 2012 13:30:01 +0000

9 Interesting Things You May Have Missed This Week

Eddie Awad — Sun, 29 Apr 2012 06:37:55 +0000

If You Have Oracle Database You Have Oracle Application Express; Use it or Lose it

Eddie Awad — Mon, 23 Apr 2012 13:00:33 +0000

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:

5 Interesting Things You May Have Missed This Week

Eddie Awad — Sat, 21 Apr 2012 18:20:28 +0000

10 Interesting Things You May Have Missed This Week

Eddie Awad — Sat, 14 Apr 2012 17:43:09 +0000

11 Interesting Things You May Have Missed This Week

Eddie Awad — Sat, 07 Apr 2012 17:45:46 +0000

“Best Practices” Should Be Renamed “Contextual Practices”

Eddie Awad — Tue, 03 Apr 2012 13:00:22 +0000

Karen Morton:

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

Use SQL to Create a Calendar in Mutliple Languages

Eddie Awad — Mon, 02 Apr 2012 16:15:12 +0000

In his post titled learning foreign languages with Oracle SQL, Matthias Rogel shares the following query (I slightly modified and formatted it for clarity):