Lewis Cunningham is an Oracle ACE Director, Oracle 11g Certified Professional (OCP), Oracle 11g Certified Data Warehouse Implementation Specialist, 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: 3 hours 19 min ago
VArrays 101
From An Expert’s Guide to Oracle Technology
Continuing on in my 101 series - I wrote about associative arrays, nested tables and
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 can use the DELETE attribute to delete individual elements so you will always want to
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),
age NUMBER );
v_person r_person;
BEGIN
v_person.fname := 'Lewis';
v_person.lname := 'Cunningham';
v_p 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 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
For those in the US - Stop SOPA!
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.
Associative Arrays 101
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
Tasklist and Taskkill
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