Skip to content

Author Archives An Expert's Guide to Oracle Technology

VArrays 101

From An Expert’s Guide to Oracle Technology
 
Continuing on in my 101 series – I wrote about associative arrays, nested tables and

Posted 31 January 2012 § Oracle § Uncategorized ‡ Comments Off °

Nested Tables 101

From An Expert’s Guide to Oracle Technology
 
A nested table is much like an associative array but you do not determine the index. The index grows by using the extend command and the index is always an incrementing integer value. You ca…

Posted 26 January 2012 § Oracle § Uncategorized ‡ Comments Off °

Record Types 101

From An Expert’s Guide to Oracle Technology
 
 
A record type is a simple structure that combines multiple datatypes into a single package.
 
DECLARE
TYPE r_person IS RECORD (
fname VARCHAR2(30),
lname VARCHAR2(30),
…

Posted 19 January 2012 § Oracle § Uncategorized ‡ Comments Off °

2011 in Review and 2012 Goals

To get where you want to be in life, you need to have goals. It doesn’t matter if you want to advance professionally, improve a hobby or lose weight, goals help you achieve your desires.
 
I think it’s important to look back at the previous year a…

Posted 10 January 2012 § Uncategorized ‡ Comments Off °

Ambiguity in SQL

I made note of the alias and then scrolled down (waaayyyy down) to the from clause and found the alias. I saw the table and did a describe. The column in the view didn’t exist in the table. WTF?!?!?!?! I scrolled back up and made sure I had the right …

Posted 05 November 2010 § Uncategorized ‡ Comments Off °

Oracle OpenWorld 2010 Day 3

From An Expert’s Guide to Oracle Technology

This post will be updated throughout the day. Refresh often for updates.

Don’t forget to check out my photos on my Flickr stream

18:00 – Southeast Technology Customer Event

This was a networking session …

Posted 21 September 2010 § Uncategorized ‡ Comments Off °

MySQL Track at ODTUG Kaleidoscope

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 da…

Posted 12 May 2010 § Uncategorized ‡ Comments Off °