Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2

This article on ORACLE-BASE describes the installation of Oracle Database 11g release 2 (11.2 64-bit) RAC on Linux (Oracle Enterprise...

14 November 2011 4 min read

Jim Tilson

Which of these things is not like the other?

Have you ever played the game where you try to identify the differences between two side-by-side seemingly-identical pictures? Sometimes answering...

11 November 2011 7 min read

Alex Nuijten

Upgrade to APEX 4.1: Invalid Login Credentials

Always a good idea to upgrade on a Friday.. not…

08 November 2011 1 min read

Patrick Barel

Dynamic Show/Hide in APEX

Understanding is required before success is possible [Dune] old Orange Catholic Bible When you want to hide and display certain...

31 October 2011 4 min read

David Njoku

Introduction to Scheduled Jobs

Psst, wanna see something cool? I bet I can read your future. Your tomorrow is going to be almost exactly...

17 October 2011 7 min read

Tim Hall

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

Enterprise Manager Cloud Control is the new name for what was previously know as Enterprise Manager Grid Control. Depending on...

12 October 2011 1 min read

Gert Poel

What’s Your Choice for Oracle Forms?

Forms was a great tool and stood for fast and easy development. You could create nice data entry applications in...

11 October 2011 6 min read

David Njoku

Introduction to Virtual Private Databases

You know the story. A group of blind men come across an elephant and each one feels a part...

04 October 2011 6 min read

Patrick Barel

Bulk Processing in Oracle Part 2

The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray...

27 September 2011 4 min read

Gert Poel

Oracle Forms Survey

Posted by Gert Poel on the the iAdvise blog: I want to call all Oracle Forms developers and administrators to...

23 September 2011 1 min read

Chet Justice

ORACLENERD T-Shirts

Recently I was asked to create some merchandise that fell outside of my norm. Specifically, I was asked to create...

20 September 2011 2 min read

Alex Nuijten

How Long is this String?

A quick puzzle from Alex Nuijten’s blog: How long is the folowing string?: to_char (10, ‘0999’) Have a think, and...

15 September 2011 1 min read

Jim Tilson

Writing Better Dynamic SQL

Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a...

14 September 2011 7 min read

Geoff Hudik

Red Gate Schema Compare for Oracle Review

From Geoff Hudik’s blog. As part of my recent role in application release management, I have had to compare and...

13 September 2011 2 min read

David Njoku

Introduction to Regular Expressions in Oracle

Regular expressions – RegEx or RegExp to their friends – were fashionably late in coming to the Oracle party. The...

06 September 2011 5 min read

Patrick Barel

Collections in Oracle Part 2

“The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This...

02 September 2011 6 min read

Alex Nuijten

Business Rule: Only One per Day, but Keep the Time

The business rule states: Only one entry is allowed per ID and per day and the time should be recorded....

30 August 2011 1 min read

Cary Millsap

Mastering Oracle Trace Data

A one-day course taught by Cary Millsap London, UK, 8 Sept 2011 Oracle trace data is an extraordinarily rich information...

19 August 2011 1 min read

Patrick Barel

Collections in Oracle Part 1

“The beginning of knowledge is the discovery of something we do not understand.” Frank Herbert. Collections are single-dimensioned lists of...

19 August 2011 5 min read

Chris Hritzuk

Can PL/SQL be Faster than SQL?

PL/SQL and SQL both are incredibly powerful languages that allow us to do some pretty amazing things with data. If...

19 August 2011 11 min read