17 October 2011
17 October 2011

Introduction to Scheduled Jobs

2
Psst, wanna see something cool? I bet I can read your future. Your tomorrow is going to be almost exactly like your today; unless it’s a weekend, in which case it’ll be almost exactly the same as last weekend. You’re welcome: that’ll be ten quid. It is a truth that life’s events – and, by extension, computer operations – ar… Read more
12 October 2011
12 October 2011

Cloud Control 12c R1 Installation on Oracle Linux 5.7 & 6.1

0
Enterprise Manager Cloud Control is the new name for what was previously know as Enterprise Manager Grid Control. Depending on the source of the material, you may still see the product described as Grid Control. This article (read it in full on Oracle-Base.com) describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 1 on Oracle Linux 5.7 and… Read more
11 October 2011
11 October 2011

What’s Your Choice for Oracle Forms?

4
Forms was a great tool and stood for fast and easy development.  You could create nice data entry applications in no time.  But now some people think Forms is dead, it doesn’t have a future or it is at the end of its lifecycle.  In this article I hope to prove they’re wrong.  And unlike the first sentence to prov… Read more
04 October 2011
04 October 2011

Introduction to Virtual Private Databases

1
  You know the story. A group of blind men come across an elephant and each one feels a part of it. One touches the tusk and goes away thinking elephants are pointy, hard and sharp; another feels its side and is amazed at how wide and featureless elephants are; and one unfortunate man feels the elephant up its backside,… Read more
27 September 2011
27 September 2011

Bulk Processing in Oracle Part 2

1
The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray Sending data back Using the bulk capabilities you can not only fetch data in one roundtrip to the database, but you can also use it to send data back to the database in a single roundtrip. Using the FORALL statement… Read more
23 September 2011
23 September 2011

Oracle Forms Survey

0
Posted by Gert Poel on the the iAdvise blog: I want to call all Oracle Forms developers and administrators to fill in this online survey about Oracle Forms. The results will be published during Oracle Open World. I’m interested in this topic (Forms and Forms Modernization) and I will be delivering a presentation at Oracle Open World about Oracle Forms(session… Read more
20 September 2011
20 September 2011

ORACLENERD T-Shirts

0
Recently I was asked to create some merchandise that fell outside of my norm. Specifically, I was asked to create a onesie, or piece baby outfit. I tried using my normal method of creating a simple png (pixel) graphic in gimp, however, when I tried to add that to something other than a regular old t-shirt, the application didn’t giv… Read more
19 September 2011
19 September 2011

Bulk Processing in Oracle Part 1

2
As you know (or may not know) there are two engines running in the Oracle database. The PL/SQL engine for executing all your PL/SQL code and the SQL engine for executing all you SQL statements. This means that every time your PL/SQL code needs data from the database, or writes to it control is passed from the PL/SQL runtime engine to the SQL.… Read more
14 September 2011
14 September 2011

Writing Better Dynamic SQL

0
Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a relatively small amount of code. Used improperly, however, it can cause all sorts of code maintenance headaches. Consider the following procedure. It uses the HR schema and sample data that comes with an installation of the Oracle database: CREATE OR… Read more
13 September 2011
13 September 2011

Red Gate Schema Compare for Oracle Review

0
From Geoff Hudik’s blog. As part of my recent role in application release management, I have had to compare and sync various objects across Oracle databases. This was not fun work and I decided to evaluate some different tools to make this easier. The tool I have been working with recently is Red Gate’s Schema Compare for Oracle. In this… Read more
07 September 2011
07 September 2011

APEX Plugin – Body Chart

0
Recently I had an inquiry via my website asking whether I was able to create a selectable body chart APEX plugin for a physiotherapy practice so they could easily highlight joint pain and record information against these selected areas. One of the challenging requirements was to allow fine grained selectivity of 16 areas on each… … Read more
06 September 2011
06 September 2011

Introduction to Regular Expressions in Oracle

16
Regular expressions – RegEx or RegExp to their friends – were fashionably late in coming to the Oracle party. The seeds of what we know today as regular expressions were formulated in the period immediately following the Second World War in fields as diverse as formal language theory and neurophysiology; but it wasn’t until the PL/SQL Web toolkit arrived for… Read more
02 September 2011
02 September 2011

Collections in Oracle Part 2

0
“The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This article follows on from Collections in Oracle Part 1 Varray The syntax for defining a varray in SQL is like this: CREATE OR REPLACE TYPE varray_type AS VARRAY(SIZE) OF element_type; The syntax for defining a varray in PL/SQL is lik… Read more
19 August 2011
19 August 2011

Mastering Oracle Trace Data

0
A one-day course taught by Cary Millsap London, UK, 8 Sept 2011 Oracle trace data is an extraordinarily rich information source for database application developers, administrators, and anyone who cares about the speed of an Oracle Database application. Oracle trace files include information that yields value throughout your software life cycle, whether you’ve bought prebuilt applications or built them yourself… Read more
19 August 2011
19 August 2011

Collections in Oracle Part 1

1
“The beginning of knowledge is the discovery of something we do not understand.” Frank Herbert. Collections are single-dimensioned lists of information, very similar to 3GL arrays. Much like ‘in-memory’ tables. Maybe that’s why they started out as PL/SQL Tables. The PL/SQL only version got renamed a couple of times. When first introduced in Oracle 7 they were called PL/SQL tables… Read more