Application Development


  Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for the pages: they can either be public or protected. Mostly you will build applications using a combination of the two. Some pages will be publicly available, like the landing page of your application, but there will also be pages… Continue Reading →

All Things Oracle Full Articles, APEX, Application Development

This video is a follow up to the webinar broadcast by Red Gate on 14th November 2012. Please leave a response and ask questions at the bottom of the page. Watch video Summary The journey of a team-developed database, from initial development to successful deployment to production, involves many stages. Regardless of the specific development methodology employed (ITIL, Scrum, etc.)… Continue Reading →

Application Development, Database Development, Webinar

Greatness is a transitory experience. It is never persistent. – Collected Sayings of Muad’Dib by the Princess Irulan In the previous article we saw how we could have different version of the code in different editions of the schema. But what about the tables? They are not editionable? This article will show you how to work ‘around’ that. Data Most… Continue Reading →

All Things Oracle Full Articles, Application Development, Database Development, Oracle Database

Having used Oracle APEX since its first appearance on the Early Adopter Platform I finally got my hands on the real thing and installed in on my test-system. This Post tries to give you a summary of the big changes in Oracle APEX 4.2 (compared to 4.1.1) from a datamodel/view/API Point of view. If you are coming from APEX 4.0… Continue Reading →


In part 1 I explained how to duplicate a single instance database using RMAN. This article will focus on converting the single instance to RAC. 2. Convert Single instance to RAC We have migrated the database successfully from Non-ASM to ASM using RMAN; the database is still running as single instance.  Now we need to convert the single instance database… Continue Reading →

10g, 11g, All Things Oracle Full Articles, Application Development, Database Administration, Oracle Database, Uncategorized

If you missed out on this year’s KScope conference, you missed out on a tremendous amount of APEX content.  You missed the APEX 4.2 preview and discussions from Oracle.  You missed great sessions on the APEX Listener, jQuery, Dynamic Actions, etc.  You missed the opportunity to actually meet some of the best APEX experts on the planet. Fear not! APEXposed… Continue Reading →


Has “database” become a dirty word within your organization lately? If you’re someone who has been a data technologist for the better part of your career, you may be wondering why the technologies you work with everyday seem to be acquiring such a bad rap. From NoSQL to No DB the current influx of brogrammers seem to take extreme pride in describing… Continue Reading →

Application Development, Database Administration, Database Development

The following video and set of resources are from the webinar broadcast by Red Gate on 03 July 2012. Watch video Key performance analysis and tuning principles apply regardless of the version of Oracle you’re using, but the Oracle 10g Diagnostics Pack instrumentation and related OEM Performance Pages built on these principles to offer a new, more visual, performance analysis… Continue Reading →

Application Development, Database Administration, Database Development, Oracle Database, Video, Webinar

I’ve been impressed with the solutions to my little problem of generating a symmetric Pascal matrix using SQL. Charles Hooper in particular has provided some very nice commentary on the problem, complete with diagrams and 2 alternative solutions. I thought I’d walk through my solution in order to explain my thought process and see if it resonates with anyone. Usually when I think about… Continue Reading →

Application Development, Database Development, PL/SQL

One of the biggest problems in software performance today occurs when the people who write software are different from the people who are required to solve the performance problems that their software causes. It works like this: Architects design a system and pass the specification off to the developers. The developers implement the specs the architects gave them, while the… Continue Reading →

Application Development, Database Development