Skip to content

Lewis Cunningham: An Expert's Guide to Oracle Technology
Syndicate content
Lewis Cunningham is an Oracle ACE Director, Oracle Certified Professional (OCP), Database Architect and self-professed database geek. Lewis has almost 20 years of database experience. Follow along as he builds a working Oracle encyclopedia, sharing his knowledge and experiences, and describing ways to integrate that technology in various projects and business areas.
Updated: 1 day 2 hours ago

Oracle OpenWorld/JavaOne/Oracle Develop 2010

Thu, 07/22/2010 - 20:16
The OOW 2010 schedule builder is up and ready to run. It's pretty cool. You can do various searches for sessions, vendors, exhibits, etc. You can also find content by user tagging. Something I would like to get a look at is the recommendation engine that's using Oracle Data Mining.
Categories: Blogs, Oracle

Modeling Address Types

Mon, 07/19/2010 - 14:00
In my previous post on Modeling Addresses, we worked through a logical model where we normalized out the parts of an address that are important to us. Now we want to model how we would attach those addresses to a person. We aren't going to cover the person entity this time. We'll save that for the future. For now we are just going to say we have a default person entity that contains a first name and a last name.
Categories: Blogs, Oracle

Modeling Addresses

Fri, 07/16/2010 - 14:00
I am going to be working mostly in a logical model and showing a potential physical representation of that model at times. I'm not going to be strict about the terms I use and I won't be digging into the meaning behind the concepts, per se. My brain doesn't work like that when I'm working and this is really to show how my brain works, and what I'm thinking about, when I do this kind of work. I will put some conceptual stuff in the first logical model and I will put some physical stuff in the logical model; it's just the way I work.
Categories: Blogs, Oracle

Microsoft won because it was easy

Mon, 07/12/2010 - 14:00
I know you must be wondering if I have just become a microsoft fanboy or possibly have lost my mind. Neither actually. Give me a few minutes to explain.
Categories: Blogs, Oracle

ODTUG Kaleidoscope 2010 - Why Guess When You Can Know?

Sun, 07/04/2010 - 16:02
So I believe I left off at Monday in my last post about ODTUG. As a matter of a fact I said I would post again the next day but didn't quite meet that. The conference has been over for a few days now but I still want to get my thoughts down.
Categories: Blogs, Oracle

ODTUG Kaleidoscope 2010 - The Journey So Far

Tue, 06/29/2010 - 13:33
So, I got to Washington on Thursday. I brought my wife and older son with me for the weekend. Getting there was an uneventful trip. The Wardman Park Marriott, where the conference is being held, is an aswesome hotel. Plenty of food near by when you don't want to eat hotel food (which I usually don't). In the last few days I've had Indian, Italian, Thai (3 times) and a sandwich. Friday was the ace di
Categories: Blogs, Oracle

Yahoo Sucks! Google wins.

Mon, 06/21/2010 - 14:00
From An Expert's Guide to Oracle Technology I originally published this on the database-geek blog but I want to share a warning about yahoo. I'm pissed. Really pissed. Advance warning: I will rant now. I forget the exact year but in the early 90s (I think 1993 or 94), I signed up for a novel service. Online email. Remember this is the early 9
Categories: Blogs, Oracle

We've had problems with that!

Wed, 06/16/2010 - 14:00
I totally get that Oracle is not bug free. But bugs in Oracle are usually a transient phenomena. Oracle employs a lot of people to fix bugs. They produce patches and new releases that fix bugs all the time.
Categories: Blogs, Oracle

Stupid Proc Tricks -The Weird and Wonderful Overload

Mon, 06/14/2010 - 13:00
From An Expert's Guide to Oracle Technology

Ran into something the other day and thought I would blog about it. No great shakes but an interesting side note. Everyone knows what procedure overloading is right? If not, read Overloading Procedures in PL/SQL before continuing.

In the post from the link above
Categories: Blogs, Oracle

Tips for Blogging and Commenting on ItToolbox

Mon, 06/07/2010 - 13:00
Learn how to efficiently search on it toolbox, format text and learn how to display HTML and XML tags in posts and comments.
Categories: Blogs, Oracle

PHP for PL/SQL Developers: Using Stored Procedures Instead of DML

Wed, 06/02/2010 - 13:00
From An Expert's Guide to Oracle Technology I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback.

My PHP Online References

Mon, 05/31/2010 - 13:25
From An Expert's Guide to Oracle Technology I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback.

PHP for PL/SQL Developers: More Include Files, Inserting Data and Must See Sites

Mon, 05/24/2010 - 13:00
From An Expert's Guide to Oracle Technology I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback.

Oracle 11g - Underground Advice for Database Administrators [Review]

Wed, 05/19/2010 - 13:00
One of the questions I get asked most frequently is: "how do I get started as a dba?" I am always on the lookout for a book that I can point to that will help answer this question. When I heard about this book, I had hopes that this would be the one.
Categories: Blogs, Oracle

PHP for PL/SQL Developers: Include Files, Connecting to Oracle and Selecting Data

Mon, 05/17/2010 - 13:00
We've finally arrived at some juicy code. This series of slides shows how to do some basic code reuse, connect to an Oracle database and then select some data. Of course, it's pointless to select the data and do nothing with it so that's covered also.
Categories: Blogs, Oracle

Know Thy Audience - Lessons on Public Presentations

Thu, 05/13/2010 - 13:00
The fact that Oracle would rewrite my query at runtime used to scare the crap out of me. After seeing the magic (which is what it felt like at first), I got used to it and have come to expect it (in the right situations).
Categories: Blogs, Oracle

MySQL Track at ODTUG Kaleidoscope

Wed, 05/12/2010 - 13:00
It looks like MySQL will be making a splash in DC this year at ODTUG Kaleidoscope. The conference organizers have announced a new MySQL track. Is this a good thing? MySQL is not really an Oracle tool, per se. It is, however, an Oracle database. As a database geek, and as an Oracle ACE Director, I like it.
Categories: Blogs, Oracle

PHP for PL/SQL Developers: Finally, some real code

Mon, 05/10/2010 - 13:00
From An Expert's Guide to Oracle Technology I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback.

ProjectManager.com - A Review

Wed, 05/05/2010 - 13:00
From An Expert's Guide to Oracle Technology Full disclosure: In exchange for an honest review, ProjectManager.com is giving me 3 licenses for the Project Management Methodology from mpmm.com. I will give those licenses away and will have details on that at a later date. Proj
Categories: Blogs, Oracle

PHP for PL/SQL Developers: A First Look

Mon, 05/03/2010 - 13:00
From An Expert's Guide to Oracle Technology I will be giving a couple of presentations this year at the ODTUG Kaleidoscope conference in Washington, DC. I am posting the presentation, in pieces, here in order to get feedback. This is the third post,