Eddie Awad's Blog

Never Ever Do That

Eddie Awad — Mon, 21 May 2012 18:11:40 +0000

ALTER TABLE sys.dual ADD (dummy2 VARCHAR2(1));

Tom Kyte:

You never, never never never, as in never ever – touch any of the SYS tables – not to insert into them, not to delete from them, not to update them and especially not to alter them.

★

The Oracle Cloud Cookbook

Eddie Awad — Mon, 21 May 2012 13:30:12 +0000

By Roddy Rodstein:

The Infrastructure as a Service (IaaS) chapters review how to plan, design, deploy and support Oracle VM for x86 with Oracle Linux, Solaris, and Windows virtual machines Managed by Oracle VM Manager and Oracle Enterprise Manager. The Platform as a Service (PaaS) chapters review how to plan, deploy and support Oracle Database and Oracle Fusion Middleware technologies on the aforementioned IaaS platform. The Software as a Service (SaaS) chapters review how to plan, deploy, support and deliver Oracle Applications in internal and external clouds.

★

★ 11 Interesting Things You May Have Missed This Week

Eddie Awad — Sun, 20 May 2012 14:00:53 +0000

Code Comments Gone Wrong

Eddie Awad — Sun, 20 May 2012 04:15:07 +0000

Dimitrios Kalogirou offers good advice:

Write self descriptive code ! Your code should be read like sentences. Avoid smart shortcuts and tricks because they break the reading… I use code comments when the code is not really self documenting. Comments should convey what code cannot. They should explain the reasons for a specific design decision, they should explain what code is supposed to achieve and why.

★

★ 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