LewisC

From  An Expert’s Guide to Oracle Technology As an official geek, I like software. Even utilities make me happy. Today I figure I will post about a few utilities that make my life easier. Every one of these is free but most have the option for paid upgrades to add space or functionality. DropBox Read Full Story

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

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 can use the DELETE attribute to delete individual elements so you will always want to Read Full Story

From  An Expert’s Guide to Oracle Technology A record type is a simple structure that combines multiple datatypes into a single package. Read Full Story

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 and see how you did as far as your goals. When I see how realistic my previous year goals were, then I can decide how to set my goals for the current year. Unfortunately, I didn't list my goals for 2 Read Full Story

From  An Expert’s Guide to Oracle Technology I rarely, if ever, bring up politics. Currently the US Congress is considering legislation that I think is reprehensible. I really can't believe that we, as a nation, have come to this. I have been reading about this for a while. I guess I have been in denial that it would really happen. Have you heard of Read Full Story

From  An Expert’s Guide to Oracle Technology An array is one way to store multiple variables in a collection. In PL/SQL we will often refer to an array of objects as a collection. If a record is a way to think of a specific row in a table, a collection type can be thought of as the rows in the table. The original pl/sql table that was offered in pl/sql is the index by table also Read Full Story

From  An Expert’s Guide to Oracle Technology At my current client, they have set a policy so that I can't run task manager. The OS is Vista Enterprise 32 bit and I only have 2GB of RAM (my 4 year old netbook is more powerful). Rebooting takes forever. I'm not sure why they have that policy. Maybe to prevent users from seeing what is running? Prevent them from stopping what is run Read Full Story

I just sat for the CIW v5 Database Design Specialist certification and passed it. Read Full Story

From An Expert’s Guide to Oracle Technology I'm asked fairly often what someone can do to move up or get promoted. I don't really have any great insight to that. I mostly just live the consultant's life and continually have my learning hat on. I want to share a lesson I learned early in my career. I have been blessed to work with some amazing people in my time. Amazing developers, DB Read Full Story