Category: Beginner Series

Beginner Series, Oracle

My Cloud Services DBaaS: Configuring the Oracle Cloud Database Service

My Cloud Services DBaaS I went ahead and jumped on the bandwagon and signed up for my very own Oracle Cloud Services Account. They make it too easy, so let’s jump right in and create a new Database Service. Obviously you will need to sign-up and get an account, which can be done right here: Cloud …

12cR2, Beginner Series

Oracle Database 12cR2 Introduces 128 Byte Identifiers

Oracle Database 12cR2 Introduces 128 byte Identifiers. Let’s take a look at a simple Table and Column name example:     If only this were available sooner … like 6 months ago (On-Prem of course). In 12cR2, the new Identifier length limit is now 128 bytes.  The 30 character limit on object names made it …

12cR2, ACE, Beginner Series, Database, DBA

Installing Oracle Database 12cR2 on Linux 7.3

What do you do when Oracle releases the long awaited 12cR2 version of the database? You download it and install it. So let’s get started. Visit the Oracle Download site and download the version 12cR2 of the database. This time it’s just a single zip file. So grab that and unzip it in a directory …

Beginner Series, Logger, Oracle

PL/SQL Instrumentation: Installing Logger

If you are writing PL/SQL, the open source tool Logger, started by Tyler Muth and now owned and maintained by Martin D’Souza is instrumental in error identification and debugging. While I am sure that there are other resources that can provide the same information, this post will show you how to get Logger installed and …

Beginner Series, Database, Oracle, REGEXP_LIKE, Regular Expressions

Pattern Matching – Regular Expressions Part 2: REGEXP_LIKE

Last month, I gave a general overview of the Pattern Matching in Regular Expressions. This post will introduce the regular expression function: REGEXP_LIKE in the Oracle Database.  Let’s get started. What is a Regular Expression Function? Regular Expression Functions in a nutshell are A set of SQL functions used to search and manipulate strings using Regular …