Eddie Awad's Blog

Developer’s Toolbox

Eddie Awad — Tue, 31 Jan 2012 13:00:59 +0000

I had the privilege to be a guest blogger on the ODTUG blog. I wrote about Kscope and my role in putting together the Developer’s Toolbox track as well as why you should attend Kscope. Here is a short excerpt:

This year’s Kscope is a special one to me. I volunteered to lead the Developer’s Toolbox track team. My task was to build a team of volunteers from the Oracle community and then together determine appropriate sub-tracks, review and rate the submitted abstracts and create a draft schedule for the track.

Read the full blog post here.

Interesting Bug

Eddie Awad — Tue, 24 Jan 2012 17:58:19 +0000

Michael posted a comment on Martin’s blog, that I previously quoted, about a “hack” to add a comment on a default value definition. Here is an example of how it works (tested in 11.2.0.1):

  SQL> CREATE TABLE t (
    2     x VARCHAR2 (10) DEFAULT 'Hi' -- There. This will be stored too.
    3  );

  Table created.

Notice the comment after the default value. The comment would be ignored, right? think again:

  SQL> COLUMN column_name FORMAT a14
  SQL> COLUMN data_default FORMAT a40
  SQL> SELECT column_name, data_default
    2    FROM user_tab_columns
    3   WHERE table_name = 'T';

  COLUMN_NAME    DATA_DEFAULT
  -------------- ----------------------------------------
  X              'Hi' -- There. This will be stored too.

  1 row selected.

Well, basically this is bug 8546537:

When trying to add a COMMENT to a table, if the ‘)’ is on a new line, then the COMMENT is successfuly created when an error should be raised. The COMMENT also makes it to the Data Dictionary. If the ‘)’ is on the same line, an error is raised.

Interesting!

Comments on Constraints and Indexes in the Database, a Good Idea?

Eddie Awad — Tue, 24 Jan 2012 16:57:19 +0000

Martin Widlake thinks so:

Comments are great, you can put 4000 characters of information into the database about each table, view and column. This can be a brief description of the object, a full explanation of what a column is to hold or even a list of typical entries for a column or table. But you can’t add a comment on indexes or constraints. Why would I want to? Well, constraints and indexes should only be there for a reason and the reason is not always obvious from either the names of the columns or the name of the constraint or index, especially where you have a naming standard that forces you to name indexes and constraints after the columns they reference.

He goes on to explain the advantages:

If I was able to add comments to constraints and indexes within the database then they would there. You move the system from one platform to the other, they are there. If for any wildly unlikely reason the central documentation lets you down, the information is always there in the database and easy to check. You may not be able to track down the original design documents but you have the database in front of you, so comments in that will persist and be very easy to find.

Martin raises very good points. I believe that it would be a useful feature to have in a future database version.

What You May Have Missed This Week: Geek Humor, Cool Developers, Database Design and More

Eddie Awad — Fri, 06 Jan 2012 17:36:25 +0000

You Should Attend This

Eddie Awad — Tue, 03 Jan 2012 19:47:32 +0000

Happy New Year!

One of the events I am looking forward to this year is ODTUG Kscope12. For those of you who have attended Kscope before, you know how much value you can get out of this conference. For those of you who don’t know what Kscope is, here is a quick introduction for you:

If you are a developer, architect, technical lead, or database administrator who works with Application Express, Business Intelligence, Oracle EPM; including Hyperion products, Essbase, Planning; Database Development or Fusion Middleware, Kscope12 is where you should be. It’s hard to find a conference that’s big enough to attract world renowned speakers and small enough to get the chance to share knowledge. Kscope12 is that conference.

This year, I will be presenting about data caching at Kscope12.

Caching is commonly used to optimize access to data that is static for a period of time. You will learn how to apply SQL and PL/SQL data caching techniques that will considerably improve the performance of your queries and programs.

Here is the abstract of my presentation:

Title: See How Easily You Can Improve Performance By Using These Four Data Caching Techniques

Detail: This presentation covers the following four database server caching techniques:

SQL Query Result Cache
PL/SQL Function Result Cache
Package-Based Cache
Deterministic Function Cache

I will show you how to use them and look at the pros and cons of each, use cases, gotchas and more.

Check out all the Kscope12 presentations by topic area:

This year, Kscope is going to be held in San Antonio, Texas at the JW Marriott Hill Country Resort.

Interesting Things You May Have Missed This Week

Eddie Awad — Fri, 16 Dec 2011 17:04:50 +0000

Interesting Things You May Have Missed This Week

Eddie Awad — Fri, 09 Dec 2011 17:14:13 +0000

Five Recently Created or Updated Oracle Support Articles

Eddie Awad — Wed, 07 Dec 2011 15:15:57 +0000

Here are five interesting My Oracle Support articles that were recently created or updated:

My Oracle Support account is required to view articles.

Upgrading from Oracle E-business Suite to Fusion Apps

Eddie Awad — Tue, 06 Dec 2011 14:30:16 +0000

Debra Lilley:

There is a third issue, after support cost, and availability, there is the big issue around the upgrade path. Oracle have always said that there would be an upgrade path from the latest two releases which at the time was 11.5.10 and 12.0, but now we also have 12.1 so there is only a path from 12.0 onwards. Is this fair, well I am not sure, in most cases I see the move to Fusion Apps as a replacement is not the best thing for an organisation, especially one who has not already moved to R12, so not having the option is not a problem.
[...]
I think a lot of people will take Fusion but in small steps, taking the co-existence route, after perhaps adopting some technology first, over time.

Interesting Things You May Have Missed Today

Eddie Awad — Wed, 30 Nov 2011 22:49:08 +0000